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:[EMAIL PROTECTED]] 
Sent: February 20, 2003 10:01 PM
To: [EMAIL PROTECTED]
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




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to