[PHP] Best Search Algorithm for Millions of record

2008-10-06 Thread Hemant Patel
My question is Whether I should go for Full Text Based search or Database Search...?And is there algorithm in php which can help me in this case...?

Re: [PHP] Best Search Algorithm for Millions of record

2008-10-06 Thread Micah Gersten
The question is, what are you searching for in the records? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Hemant Patel wrote: My question is Whether I should go for Full Text Based search or Database Search...?And is there algorithm in php which can help

Re: [PHP] Best Search Algorithm for Millions of record

2008-10-06 Thread Nathan Rixham
Stut wrote: On 6 Oct 2008, at 07:17, Hemant Patel wrote: My question is Whether I should go for Full Text Based search or Database Search...?And is there algorithm in php which can help me in this case...? I can fully recommend Sphinx Search: http://sphinxsearch.com/. It's not as easy to

Re: [PHP] Best Search Algorithm for Millions of record

2008-10-06 Thread Stut
On 6 Oct 2008, at 07:17, Hemant Patel wrote: My question is Whether I should go for Full Text Based search or Database Search...?And is there algorithm in php which can help me in this case...? I can fully recommend Sphinx Search: http://sphinxsearch.com/. It's not as easy to implement as

Re: [PHP] Best Search Algorithm for Millions of record

2008-10-06 Thread Stut
Please keep replies to the list so everyone can benefit from the discussion. On 6 Oct 2008, at 13:13, Hemant Patel wrote: I found on other blogs that Lucene Implementation is quite easy and flexible also...Is there any major differences between Sphinx and Lucene ...if you know then please

Re: [PHP] Best Search Algorithm for Millions of record

2008-10-06 Thread Hemant Patel
Yeah sure...I have read about Lucene Implementation in Zend Framework and its Lucene Search class will help us to easily create our Text Based Search Functionality in our own application. http://devzone.zend.com/node/view/id/91 But still i am asking...if anybody has ever worked on other Full Text

Re: [PHP] Best Search Algorithm for Millions of record

2008-10-06 Thread Nathan Rixham
Hemant Patel wrote: 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 And I have to maintain my response time as less as possible... Looking forward to your help

Re: [PHP] Best Search Algorithm for Millions of record

2008-10-06 Thread Micah Gersten
What type of data is in the fields? Also, which database engine? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Hemant Patel wrote: I have couple of tables with 1,60,0 records and now i need to search the records based on some crieteria...so which

Re: [PHP] Best Search Algorithm for Millions of record

2008-10-06 Thread Hemant Patel
It will be a Postgres SQL Database and Fields will be like descriptive as well as Area of land,of street etc specific... With Regards, Hemant Patel On Mon, Oct 6, 2008 at 8:30 PM, Micah Gersten [EMAIL PROTECTED] wrote: What type of data is in the fields? Also, which database engine? Thank