1 message in com.mysql.lists.javaMySQL ResultSet performance
FromSent OnAttachments
Paul Weissman16 Feb 2000 09:46 
Subject:MySQL ResultSet performance
From:Paul Weissman (pwei@austin.rr.com)
Date:02/16/2000 09:46:57 AM
List:com.mysql.lists.java

Couldn't find any information on this in any FAQ that I searched. Any ideas?

I'm doing a fairly straightforward SQL call from Java/Jdbc to a MySQL database and storing the output into a ResultSet. Each query asks for about 40-50 double values from the database per row. Large queries return about 2000 rows. My code then reads the values into a double[] array like the following:

for (int i = 1; i <= sizeofrecordset; i++) arr[i-1] = RS.getDouble(i);

So, in effect, I'm doing 80,000 to 100,000 getDouble() calls. I would think that this would be a trivial operation, but it takes around 8 seconds. Any way to improve this performance or is this normal?

Thanks! Paul