Slow Performance on database access

[LNunes]

Hi all!

Is there another way to keep a DB with 50000 docs more "fast" to open? I have one DB with more than this, about 250000 with the same problem. I tried to create a Full Text index, but a view that selects "all docs" takes, in some cases, more than 1 hour to open for some users.... And I really need to select all docs in this case...
Any Idea?

 

[pmonett]

More than 1 hour to open ?!!
It seems to me that something is horribly wrong here. Are you sure the server is up to supporting the number of users you have ?
Check if there are any tasks or agents that are taking up processing time when they shouldn't.
Also, try replicating the db locally and creating an FT index on the local replica. If the client takes horribly long to open that, then you have a db problem.
Also, try and find out if the db's views are correct, not corrupted and up to date before doing a search.