Hi
One of my sqlite query executes faster in sqlite manager( firefox addon
) but take a lot of time to execute using a java program. Here is the
snippet
PreparedStatement mStatement;
ResultSet mResults;
CachedRowSetImpl impl=null;
Connection mconn = null;
try
{
Class.forName("org.sqlite.JDBC");
mconn = DriverManager.getConnection("jdbc:sqlite:" +
"database.db");
mStatement = mconn.prepareStatement(jobQuery);
long startTime = System.currentTimeMillis();
mResults = mStatement.executeQuery();
long endTime = System.currentTimeMillis();
System.out.println(jobQuery);
System.out.println("Time taken to execute query ==>"
+(endTime - startTime));
impl = new CachedRowSetImpl();
impl.populate(mResults);
mStatement.close();
mResults.close();
}
catch (SQLException e) {
e.printStackTrace();
}
Is there anything that I am missing while connecting using java ? Any
help appreciated.
Sridhar
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
