I just realized, I think that indices may not avail you when you're doing a search 
based on double-sided wildcards.  

I'm afraid you may be forcing a full table-scan by performing that kind of search.

So run a few benchmark tests.  Maybe populate a test database with a large volume 
(like 100,000 rows or more) so you'll notice performance differences, and then run a 
few tests. 

Cheers,
-Peter


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to