Re: Best Search Algorithm for Millions of record
| From: | Michelle Konzack | Date: | Fri, 10 Oct 2008 01:31:51 +0000 |
| Subject: | Re: Best Search Algorithm for Millions of record | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-281662@lists.php.net to get a copy of this message | ||
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)