Thanks For your help
Actually i am using v051 before , but now i changed to v052 (native)
its working fine...
Thank you again
On Jul 5, 12:42 am, "David Crawshaw" <[EMAIL PROTECTED]> wrote:
> 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]
-~----------~----~----~----~------~----~------~--~---
