7 messages in com.mysql.lists.javaRE: threading in driver| From | Sent On | Attachments |
|---|---|---|
| Matthew Pocock | 23 Jun 2003 07:49 | |
| Mark Matthews | 23 Jun 2003 08:05 | |
| Shankar Unni | 23 Jun 2003 10:38 | |
| Shankar Unni | 23 Jun 2003 11:29 | |
| Kevin Fries | 23 Jun 2003 11:44 | |
| Mark Matthews | 23 Jun 2003 11:50 | |
| Shankar Unni | 23 Jun 2003 13:49 |
| Subject: | RE: threading in driver |
|---|---|
| From: | Kevin Fries (kfr...@kurant.com) |
| Date: | 06/23/2003 11:44:16 AM |
| List: | com.mysql.lists.java |
Mark,
Interesting. The JDBC api says that the TYPE_FORWARD_ONLY + CONCUR_READ_ONLY is the default for createStatement(). Was the driver done this other way on purpose? Or might it change in the future?
-----Original Message----- From: Shankar Unni [mailto:shan...@cotagesoft.com] Sent: Monday, June 23, 2003 11:30 AM To: ja...@lists.mysql.com Subject: RE: threading in driver
Mark Matthews wrote:
stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);
stmt.setFetchSize(Integer.MIN_VALUE);
Ah, that's interesting, thanks.
What happens if we set the fetch size to something other than MIN_VALUE (say, 20)? Will it disable this whole streaming, or just stream in the rows 20 at a time? (Trade-off between memory usage and network/IPC efficiency..)?
-- Shankar.
-- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/java?unsub=kfr...@kurant.com