You are probably using the "pure" driver, which is slow. I suggest using a native driver. What operating system and architecture are you using?
d. 2008/7/4 Ramesh <[EMAIL PROTECTED]>: > > 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] -~----------~----~----~----~------~----~------~--~---