I'm using 6.12 on prem in my company. We have basically 2 FC used. Bigger one with more than 1 million files.
I have more than one hundred users. Users log in with their access code. And this code is the key for the index profile in the bigger FC.
So users views only their files, obviusly. Also same index profile has filter for document type.
With DWADMIN user, that has no limitations, full text search is very speed, neverthless big amount of files.
With normal users speed is very low. If usually with DWADMIN takes few seconds for a search, for normal users most times goes in timeout.
Or in the best case, takes more than 20/30 seconds.
Do you have any idea of such a behaviour ?
Is there something I could do to improve performance ?
You know, in many cases, full text help users to find statements that were not possible to index...
Any help and suggestion is appreciated.