Multiple SELECT ResultSet rows per packet? - Barnet Wagman - com.mysql.lists.java

2 messages in com.mysql.lists.javaMultiple SELECT ResultSet rows per pa...

From	Sent On	Attachments
Barnet Wagman	22 Jan 2004 11:41
Mark Matthews	22 Jan 2004 12:00

Subject:	Multiple SELECT ResultSet rows per packet?
From:	Barnet Wagman (bw...@northbranchlogic.com)
Date:	01/22/2004 11:41:11 AM
List:	com.mysql.lists.java

From the MySQL manual, I gather that every row of a ResultSet gets transmitted back in a separate packet. Is there anyway of getting multiple rows (or an entire ResultSet) into a single packet?

I sometimes have SELECTs that yield large numbers of small (in terms of bytes) rows. The overhead associated with a packet transmission is relatively high, so if multiple rows or an entire ResultSet could go into one packet, it could speed things up considerably, particularly since 4.0 supports large packets.

Thanks,