Re: php/mysql query
| From: | Fredrik de Vibe | Date: | Fri, 21 Feb 2003 09:32:08 +0000 |
| Subject: | Re: php/mysql query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25817@lists.php.net to get a copy of this message | ||
webmaster@iparenting.com (Julie Keywell) writes:
> 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.
I'm thinking join somehow, but I'm not sure I completely understand
the question. Post the query and table structure (you should change
the table names first, I guess, and only the necessary tables), and
maybe I for one can say more. :-)
--
--Fredrik
... and furthermore ... I don't like your trousers.