Currently (before mysql update to latest version) it seems like the termcollection index is not used in queries, but only the fulltext index.

This of course slows down the queries.

A query in a single termCollection (filter set to this collection) should always be as fast as if it would be one table per collection. If this is not achieveable (or nearly achieveable) we should switch to one table per collection (what Pavel could implement).

Especially the performance of searching short strings or using * or ? in a query should be improved.