[basex-talk] Server Performance

2022-11-23 Thread Johannes Bauer
Hi all, we have two Linux server VMs where our BaseX application is running - Integration - Production The used database is about 5 GB including a fulltext index and is identical on both systems. The production VM is more potent in all aspects (CPU, RAM, Disk IO, ...). Dispite all of that we

[basex-talk] Fulltext search with wildcards

2022-11-23 Thread Johannes Bauer
Hi, I have another question regarding fulltext search performance with wildcards. Our fulltext index is rather big with 1.3 GB and about 500.000 entries. When I use the following search where there are no matches: *ft:search('db', 'CT020/.*/P', map{'wildcards':true()})* it takes about 10 second

Re: [basex-talk] Fulltext search with wildcards

2022-11-23 Thread Christian GrĂ¼n
Hi Johannes, It was a courageous decision by the writers of the XQFT spec to include support for wildcards. The resulting semantics turned out to be very sophisticated and sometimes counter-intuitive (with all the gory details being left to the implementors). Wildcards search will be applied to t