RE: [PHP-DB] php/mysql query
| From: | Kelly Protsko | Date: | Fri, 21 Feb 2003 05:09:17 +0000 |
| Subject: | RE: [PHP-DB] php/mysql query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25813@lists.php.net to get a copy of this message | ||
Well if the zip codes have something in common just do a pattern match
for them or are you just picking random zip codes? This way you only
need one one sql statement to bring everything back.
Kelly
-----Original Message-----
From: Julie Keywell [mailto:webmaster@iparenting.com]
Sent: February 20, 2003 10:01 PM
To: php-db@lists.php.net
Subject: [PHP-DB] php/mysql query
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
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php