[Phpmyadmin-devel] About bug #461192

[Loïc]

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

 
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif