[sqlite] sqlite queries execute faster in sqlite manager addon but take a lot of time to execute using a java program

[Sridhar Polavarapu]

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