php/mysql query
| From: | Julie Keywell | Date: | Fri, 21 Feb 2003 05:00:56 +0000 |
| Subject: | php/mysql query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25812@lists.php.net to get a copy of this message | ||
Hi there!
I am querying our database for 11,000 different zip codes and it seems
to be overloading MySQL. However, common sense says it shouldn't.
My question is:
When needing to query 11,000 things, is it best to make 1 SQL statement
that has 11,000 ors, or run through individual querys 11,000 times? Any
help would be wonderful! I am making PHP do the counting rather than
MySQL.
Thanks!
Julie
--