Welcome to WebmasterWorld Guest from 50.19.190.144

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

similar_text problem

Too much processing power with long strings comparison

     
10:49 pm on May 8, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Mar 2, 2004
posts:125
votes: 0


I'm running a PHP script on my server which compares long strings (up to 40k each), so I'm using the similar_text command.

The problem is its just taking far too long for comparisons, sometimes up to 3 or 4 minutes for just a couple of comparisons.

I was just wondering if there are any more efficient comparison methods. I'm well aware of soundex, metaphone and levenshstein comparisons, all of which are far too innacurate.

I'm willing to consider the merits of other technology/software if it can speed up the whole process. Does MYSQL have any similarly accurate comparison functions?

Thanks

9:59 am on May 9, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Mar 2, 2004
posts:125
votes: 0


no one?
10:25 am on May 9, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Sept 30, 2004
posts:95
votes: 0


Check out this link: [dev.mysql.com...]