[basex-talk] Fulltext search with wildcards

[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 seconds to get the empty result. The query requires a big 
amount of free memory. If I use this query here (that also has no 
matches): *ft:search('db', 'CT.*/20/P', map{'wildcards':true()})* it 
only takes about some milliseconds. Any ideas why the placement of the 
wildcard has such big impact on the performance? Best Regards Johannes