[Phpmyadmin-devel] About bug #461192

Marc Delisle DelislMa at CollegeSherbrooke.qc.ca
Wed Sep 19 08:59:02 CEST 2001


I think that by removing LIMIT and using data_seek, we will have memory problems SELECTing large
tables and sending them in the PHP "result" variable.

"a pointer to get only n records": how do you do that?

mysql_unbuffered_query is available in PHP >= 4.0.6.


Loïc a écrit :
> Hi All!
> Trying to find a way to fix this bug (wrong counted
> rows with "group"-queries), I've found that... the
> convenient parser to build would be really too complex
> and really hard for the server.
> Then I'm thinking about an other way to handle
> "SELECT" queries ie remove the "LIMIT" clause
> that was added by PMA and use:
> - "mysql_data_seek" to move to the first record
>    that should be displayed;
> - a pointer to get only n records.
> Of course this will increase a bit the server charge
> but not too much since MySQL applies the LIMIT
> clause in a second time (it applies it on the internal
> result array obtained from the SELECT statement).
> Does anybody have a better solution?
> Regards,
> Loïc

More information about the Developers mailing list