19 Sep
2001
19 Sep
'01
11:59 a.m.
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