PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > How-to Forum

Reply
 
Thread Tools
Old 03-23-2004, 10:28 AM   #1
Korben
Green Mole
 
Join Date: Mar 2004
Posts: 1
Question 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
Korben is offline   Reply With Quote
Old 03-24-2004, 01:55 AM   #2
jerrywin5
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!
jerrywin5 is offline   Reply With Quote
Old 03-24-2004, 09:21 AM   #3
Charter
Head Mole
 
Charter's Avatar
 
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.
Charter is offline   Reply With Quote
Old 03-24-2004, 10:51 AM   #4
jerrywin5
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?
jerrywin5 is offline   Reply With Quote
Old 03-24-2004, 11:59 PM   #5
Charter
Head Mole
 
Charter's Avatar
 
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.
Charter is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT -8. The time now is 03:25 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.