RE: LIMIT and get_num_rows
| From: | pwestergaard at sympatico dot ca | Date: | Mon, 14 Jan 2002 18:31:50 +0000 |
| Subject: | RE: LIMIT and get_num_rows | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15788@lists.php.net to get a copy of this message | ||
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