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]
-~----------~----~----~----~------~----~------~--~---

Reply via email to