Am 2008-10-06 18:05:41, schrieb Hemant Patel: > But still i am asking...if anybody has ever worked on other Full Text Based > Search Algorithm then please help me to choose the best one as I need to > search in 160,00,000 records....
Realy 16 million records?
I you use PostgreSQL, I recomment to use at least version 8.3 with
"table partitioning" otherwise you could hit some limits on a singel
table (it happen to me, but with over 200 columns and 500.000 rows)
Also I recomment to use "tsearch2" which let you do fulltext search.
Thanks, Greetings and nice Day/Evening
Michelle Konzack
Systemadministrator
24V Electronic Engineer
Tamay Dogan Network
Debian GNU/Linux Consultant
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
+49/177/9351947 50, rue de Soultz MSN LinuxMichi
+33/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)
signature.pgp
Description: Digital signature
