Re: Determining the similarity between a user supplied short piece of text (between 5 and 15 characters) and a list of similar length text items.
| From: | tedd | Date: | Mon, 19 Jul 2010 18:46:38 +0000 |
| Subject: | Re: Determining the similarity between a user supplied short piece of text (between 5 and 15 characters) and a list of similar length text items. | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-307021@lists.php.net to get a copy of this message | ||
At 12:39 PM +0100 7/19/10, Richard Quadling wrote:
I'm using MS SQL, not mySQL. Found a extended stored procedure with a UDF. Testing it looks excellent. Searching for a match on 30,000 vehicles next to no additional time - a few seconds in total, compared to the over 3 minutes to search using SQL code.That seems a bit slow. For example, currently I'm searching over 4,000 records (which contains 4,000 paragraphs taken from the text of the King James version of the Bible) for matching words, such as %created% and the times are typically around 0.009 seconds. As such, searching ten times that amount should be in the range of tenths of a second and not seconds -- so taking a few seconds to search 30,000 records seems excessive to me. Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com