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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
