Re: DB - Query(limit) vs. LimitQuery() in MySQL

From: Date: Tue, 28 Sep 2004 11:58:33 +0000
Subject: Re: DB - Query(limit) vs. LimitQuery() in MySQL
References: 1 2 3  Groups: php.pear.general 
Request: Send a blank email to pear-general+get-14655@lists.php.net to get a copy of this message
Tommy Ipsen wrote:
Does this mean that LimitQuery doesn't extract *all* the records from the table and *then* extracts the necessary ones but rather translates the use of LimitQuery to a MySQL-standard query (SELECT ... LIMIT a,b) hence taking advantage of MySQLs LIMIT option?
Lazy/Stupid question... (sorry!) - I looked in the source code and it looks like limitQuery() does takes advantage of MySQL's special syntax for limiting the recordset! Cheers, Tommy Ipsen

« previous php.pear.general (#14655) next »