[Hawkey]

Hi Peter, you are righ. MySql client/server is half duplex, so without clause LIMIT client gets all resultset. Thanks, Hawkey

[Hawkey]

Thank you very much, your answer is very helpful for me.. better to know that it's impossible then think about it. So is there any other possibility – retrieve all resultset in real time without buffering and then see some real time about Sending data in Profiling? I know, there is some parameter on MySQL Server for switch-off buffering, will it work with SQLyog? Thank you, Hawkey

[Hawkey]

Hi,

I'm not sure adding limit to every query is clever thing, limit clause changes execution of query. I try some comparison the same statement of query on Oracle and on MySQL, for Oracle I have a client PL/SQL developer and there is possibility show only first 100 rows… but the query makes all work, not only for first 100 rows. When I use Profiling in SQLyog, I see duration time of sending data to client 2x smaller then in Oracle. But I don't believe it, I thing that SQLyoq shows only some rows and the rest reads from buffer in library. But the Sending time is only for small part of the resultset. Sorry, I have filled in the title of my question word LIMIT and your association was correct, so I repair my question : is some possibility in SQLyog to execute all query but in result window see only 100 first rows ?

Hawkey

[Author]

Posts