[Phpmyadmin-devel] About bug #461192

[Marc Delisle]

Hi,

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.

Marc

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
>