BTS config and space estimates questions
Posted in 2020
Hi all, our developers plan to implement fulltext functionality using BTS in the application and I have a couple of questions and I did not find the answers in docs: Sizing of sbspaces - is there any estimate formula or rule of thumbs on bts_index size? - is there any estimate formula or rule of thumbs on temporary space needed for bts_index creation Memory requirements - on what depends virtual memory needed for fulltext query (size of result set, size of index etc), is Bufferpool used for bts_indexes - which size? (standard ie 4kb on aix) Concurrency and locking - can 1 bts vp run more than 1 bts query concurrently? - what is an cost of insert/delete/update of a row with bts column? the whole index must be rewritten or just a part? PDQ - can PDQ help bts index creation? or PSORT_NPROCS Thanks a lot for any tip ------------------------------ Milan Rafaj ------------------------------ #Informix