JDBC Result closing takes ists time

[Daniel Schneller]

Hi ,

i am reading 1000 Elements from a database (500.000 all together).
The problem is reading the data takes only a few miliseconds but
closing the ResultSet takes another 22 seconds. My Hard Disk tells me
that the ResultSet is probably running to the end of my table row by
row. Is there a way to tell mysql not to do this ?

Statement tempStmnt = aConnection.cre ateStatement();
tempStmnt = aConnection.cre ateStatement(
java.sql.Result Set.TYPE_FORWAR D_ONLY,
java.sql.Result Set.CONCUR_READ _ONLY);

tempStmnt.setFe tchSize(Integer .MIN_VALUE);

Date tempStart = new Date();
ResultSet tempRs = tempStmnt.execu teQuery("SELECT * FROM
ARTIKELSTAMMDAT EN");
int tempXx = 0;
while (tempRs.next() && tempXx++ < aCount) {
tempRs.getStrin g("artikelBezei chnung");
}

Regards Daniel Schneller