> 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.
