Veröffentlicht Sat, 30 Mar 2019 05:50:08 GMT von Sabino Civita
Hello everybody,
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.

Thanks

Sabino 
Veröffentlicht Tue, 02 Apr 2019 05:18:23 GMT von Sabino Civita
Hello everybody,

does anyone have any idea ?

Thanks & regards

Sabino
Veröffentlicht Tue, 02 Apr 2019 10:02:31 GMT von Phil Robson DocuWare Corporation Senior Director Client Services, Americas
Sabino,
Try adding a database index to the field or fields that the index filter uses. On large file cabinets correct database indexes are a must to ensure best performance.


Phil Robson
Senior Director Support Americas
Veröffentlicht Tue, 02 Apr 2019 12:10:05 GMT von Sabino Civita
Hello Phil,
thank you for answer.
But what do you mean exactly ?
Add a full text index in SQL, for example ?

Thanks

Sabino
Veröffentlicht Tue, 02 Apr 2019 12:23:30 GMT von Phil Robson DocuWare Corporation Senior Director Client Services, Americas
Assuming you are using Microsoft SQL Server, see this article.
https://www.mssqltips.com/sqlservertip/5573/creating-indexes-with-sql-server-management-studio/

In particular, see the section on creating a  non-clustered index.



Phil Robson
Senior Director Support Americas
 

Sie müssen angemeldet sein um Beiträge in den Foren zu erstellen.