mySQL result sets - on client or server

[ponToon]

Does the result set reside on the client or server side? For the sake of performance, I would like to know, for example, when you perform a "fetch row" operation, if mySQL has to make a round-trip to the server every time.

 

[danielhozac]

The result sets are stored at the client. //Daniel

 

[sleipnir214]

danielsan,

Do you have a technical reference on that answer? ______________________________________________________________________
TANSTAAFL!

 

[danielhozac]

No, but since you can fetch records, delete one of them and the show the fetched records including the deleted one, that's what I assume. //Daniel

 

[piti]

i'm too for the client side oppinion as you can disconnect from the mysql server and still use the result set

 

[sleipnir214]

I'm wondering what the limit is. MySQL has a limit by default of 16MB per communication.

What happens if you get crazy and perform a "SELECT * ..." on a table that will provide more than 16MB in the return? ______________________________________________________________________
TANSTAAFL!

 

[KarveR]

The server normally goes into a state of shock and hides from you until you restart it.

*note to self: don't select * on a table with 2,850,000+ records on a saturday when you are not near the server. ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.