BTS config and space estimates questions
Answered: red (hollow confidence) — Multi-part BTS sizing, memory, concurrency and PDQ question with no replies archived.
Advisory only.
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