|
03-23-2004, 10:28 AM | #1 |
Green Mole
Join Date: Mar 2004
Posts: 1
|
PHPDig or MySQL Full Text ?
Hello everyone,
I am looking for a powerful indexer/search engine for my website and PHPDig seems to have everything I need. I also "digged" into the MySQL doc and saw that MySQL has support for full-text indexing and searching and allows boolean search. Has anyone benchmarked the two solutions and can show me the best way to go : PhpDig or MySQL Full Text ? What do you think ? Thanks ! Cheers, Korben |
03-24-2004, 01:55 AM | #2 |
Orange Mole
Join Date: Mar 2004
Posts: 48
|
MySQL Full-text Search
It appears that PHPDig uses a hand coded version of full-text search rather than the MySQL Full-text Search feature. Will you please take some time and explain why? How do they compare?
Thank you! |
03-24-2004, 09:21 AM | #3 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
Hi. The MATCH AGAINST capabilites were introduced in the MySQL 3.23.23 version, do not allow for partial word matching, and exclude results where keyword can be found in over half of the rows. The IN BOOLEAN MODE capabilites were introduced in MySQL 4.0.1 and are not available in MySQL 3.23.x versions. MySQL 4.0.x reached production level in the spring of 2003, and there are many users who still utilize MySQL 3.23.x versions. PhpDig was written to store keywords and use those keywords to pull results from text files. This circumvents certain limits with MATCH AGAINST queries and avoids using LIKE queries on pages of text. When MySQL 4.x.x becomes the standard package for all MySQL users, PhpDig would need major changes in order to make use of IN BOOLEAN MODE capabilities.
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension. |
03-24-2004, 10:51 AM | #4 |
Orange Mole
Join Date: Mar 2004
Posts: 48
|
What else can you tell us about how they compare?
If each were searching against the same database, which would return search results faster and why? Which method will start to slow down faster as the number of files indexed grows and why? Are you saying that once MySQL 4.x.x becomes standard for users that PHPDig will be converted to implement MySQL's Full-Text Search instead of the current method? |
03-24-2004, 11:59 PM | #5 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
Hi. As I haven't written a MATCH AGAINST version of PhpDig, I am unable to provide benchmark information for comparison. MySQL 4.x.x as standard does not guarantee a new release of PhpDig.
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension. |
Thread Tools | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using non-root MySQL account with phpDig | muppet | How-to Forum | 0 | 01-22-2006 08:08 AM |
PhpDig only with Mysql | vodevil | How-to Forum | 8 | 04-30-2005 06:16 PM |
PhpDig and Mysql without text_content | vodevil | Script Installation | 1 | 04-06-2005 02:42 PM |
How does PhpDig epure text? | Edomondo | How-to Forum | 1 | 03-03-2005 09:17 AM |
PHPDig 1.8.8 RC1 and MySQL | djavet | Script Installation | 2 | 02-01-2005 12:02 AM |