HELP ! P R E F E T C H -- Trick to using prefetch in JDBC with Oracle
From: Peter B. Nelson <PBNelson_at_Black-Hole.com>
Date: 1999/05/26
Message-ID: <374c2253.101852546_at_news1.newscene.com>#1/1
OracleCallableStatement.setRowPrefetch(100)
OracleCallableStatement.getRowPrefetch()
CallableStatement stmt = this.conn.prepareCall("select * from party where rownum < 25");
stmt.executeQuery();
Date: 1999/05/26
Message-ID: <374c2253.101852546_at_news1.newscene.com>#1/1
...so, I need to increase the prefetch queue size.
Is there a trick to using the OracleStatement.defaultRowPrefetch option? Here's what I tried:
OracleCallableStatement.setRowPrefetch(100)
should set my prefetch queue, from its default of 10, to 100. However, judging from performance, the prefetch queue size doesn't change. Even though the statement:
OracleCallableStatement.getRowPrefetch()
returns 100, my SQL retrieves are abysmally slow whenever the result set exceeds 10, which is the default size.
Here is an example of my select statement:
CallableStatement stmt = this.conn.prepareCall("select * from party where rownum < 25");
stmt.executeQuery();
Is there something else I must do to make the prefetch queue bigger/faster? Do I need to switch a boolean, or something?
P.S. I'm using jBuilder 2 with Oracle 8 JDBC drivers v1.11, downloaded 5/25/99. Received on Wed May 26 1999 - 00:00:00 CEST