Re: [PHP3] More info about search engine

In article <393FC98C.BA2FF92C@701.com>, abubic@701.com (Alen Bubic) wrote: > In response to the several emails that I have received rather quickly... > > Planning on bringing 8 to 10 million residential and commercial > telephone directory listings to the web. The telephone directory needs > to be searchable by an individual's name or by a company's name. In > order to improve the speed of the search, I believe some sort of > indexing software would be required. I could be wrong, and often am, but I think either Oracle, Sybase, or PostgreSQL, and probably even MySQL will cheerfully search an indexed char(30) field for names in 8-10 million records without being inordinantly slow. Try a test case with PostgreSQL (free) and 10 million records randomly generated... Just be sure that you have an index on that field, and that it's not varchar or text: A static number of characters is faster. You'll need buttloads of disk space for the database tables and their index, obviously. -- Richard Lynch | If this was worth $$$ to you, buy a CD US Customer Support Director | from one of the artists listed here: Zend Technologies USA | http://www.L-I-E.com/artists.htm http://www.zend.com | (this has nothing to do with Zend, duh!)