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