On Mon, 26 Sep 2005, Yonatan Ben-Nes wrote:
Hi again everyone,
Oleg I tried tsearch2 and happily it does work wonderfully for me returning
results extremly fast and actually its working even better then I wanted with
all of those neat features like: lexem, weight & stop words.
I got only one problem which is when I want the results to be ordered by a
diffrent field (like print INT field) it takes quite alot of time for it to
do it if the query can return lots of results (for example search for the
word "computer") and thats even if I limit the results.
The best way to improve its speed for such quereies (that I've found...) is
to create an index on the field which I want to order by and using it CLUSTER
the table, after the clustering I drop the the index so it won't be used when
I run queries with ORDER BY on that field, that seem to improve the speed, if
anyone got a better idea ill be glad to hear it.
what's your actual query ? have you tried multicolumn index ?
Anyway thanks alot everyone!
Ben-Nes Yonatan
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
