RE: [PHP-DB] LIMIT
| From: | Sam Masiello | Date: | Fri, 30 Jun 2000 14:21:30 +0000 |
| Subject: | RE: [PHP-DB] LIMIT | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-784@lists.php.net to get a copy of this message | ||
How would grabbing all of the information once and looping through it once
be more of a load than multiple mysql() calls? The method I presented would
run in O(n) time whereas doing multiple mysql calls to do grab the
information in small pieces, would be greater than that.
Sam Masiello
System Analyst
Chek.Com
(716) 853-1362 x289
smasiello@chekinc.com
-----Original Message-----
From: Torsten Curdt [mailto:tcurdt@dff.st]
Sent: Friday, June 30, 2000 10:17 AM
To: Sam Masiello; php-db@lists.php.net
Subject: RE: [PHP-DB] LIMIT
> It depends on exactly what you want to do with the data....for example...
> If you grab ALL of the data with one query (not using the LIMIT
> statement),
Well, that would be easy... But considering the
permformance/load impact (don't know if it is a
big one - but I guess so) I want to use LIMIT!
--
Torsten