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.
RE: [sqlite] Use sqlite on solaris with java in multithreaded web application
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.
Re: [sqlite] Use sqlite on solaris with java in multithreaded web application
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. I don't know about the java/sun interface to sqlite. I have used it on linux and windows and it's worked very well for me. Others on this list might know more.
