Depends what you're after. Your query should always return exactly the
data you are after. Your tables should be arranged so that is possible.

---John Holmes...

> -----Original Message-----
> From: Jed Verity [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 29, 2002 5:10 PM
> Subject: [PHP] Newbie Q: Fetching vs. Looping
> Hello Again, Folks,
> I've been testing this for a while and keep coming up with mixed
> In
> general, is it faster and more efficient to query a MySQL database
> with
> a large SQL select statement and then loop through the huge resulting
> table?
> Or does it make better sense to perform a number of smaller queries
> smaller resulting tables?
> This is the kind of stuff they just don't seem to talk about in the
> manuals.
> Any insight is appreciated. Sorry for the ignorant question!
> Jed
> --
> PHP General Mailing List (
> To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to