whit the same code
Statement stmt = getConnectionStatement(var,from);
stmt.setMaxRows(1);
stmt.setFetchSize(1);
t = System.currentTimeMillis();
rs = stmt.executeQuery(query);
answers slowly respect to HXTT Access JDBC30 trial version.
|
Because MS Access format database need to query and load some other tables for the first query, you can find the quicker speed for the following 2nd, 3rt, ..., queries.
|