|Post date: 2007-11-14 17:13|
Hello, i want to ask, if somebody could help me out of this problem.
We have quite big database, ca 10 GB (most of them are attachments). The FT index has 2 GB, quite big as well.
Is it normal, that the ftsearch query needs ca 1-2 minutes for each to find the result?
Sometime in 30s, or 9s, but the 5 minutes searching time is quite too big.
Im using an agent and view.FTSearch ( in 38 000 documents ).
Is the time ok? How to improve the search speed?