Hi Jay, Thanks for your immediate reply.
I will send you schema and query for which I feel there is problem. On the other hand the driver I used for connection between java and sqlite (javasqlite- http://www.ch-werner.de/javasqlite/) states that this driver is tested only in Linux. I was wondering even if I should use SQLite with java on solaris in live applications. Regards, Nitin -----Original Message----- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 6:59 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Use sqlite on solaris with java in multithreaded web application > Hi, > > I want to use sqlite as database in Solaris Environment in Java based web > application. There can be multiple read only requests coming to database at > same time. I tried using javasqlite driver for using sqlite with Java but as > number of users or request increase response time increase drastically and > sometimes jsp page doesn't even render in browser. > > Is it advisable to use sqlite in solaris with javasqlite driver in > multithreaded environment? OR there is any other better driver. I even tried > using 3.3.5 version of sqlite. I would look at the indexes on your database. Which queries are slowing response time? You might share the query and schema with us so we can help you optimize them.