RE: [PHP-DB] LIMIT
| From: | Torsten Curdt | Date: | Fri, 30 Jun 2000 14:27:42 +0000 |
| Subject: | RE: [PHP-DB] LIMIT | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-786@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.
But we're talking about a page viewing mechanism... like:
<<start <prev next> end>>
So you do these SELECT statements only if the user
requests it.
<user requests page>
select * from blub limit 0,40
<user needs some time to read>
<user presses "next" button>
select * from blub limit 40,40
<user needs some time to read>
...
So on a per "button-press" basis it will be faster!Correct?!
--
Torsten