Actually i am executing a query that have three joins in it ,
It is making me to wait more than 10 seconds when i try to execute it
through java ,
but through command line it is taking not more than 1 second ...
My code goes like this..
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:C:\
\test.db");
Statement stat = conn.createStatement();
//place where it takes more time
ResultSet rs = stat.executeQuery(complex_query);
//place where it takes more time
Do you have any suggestions for me to make it fast
Are there any other classes for connecting to sqlite DB??
Thanks in advance for your help...
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
