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