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. Any help will be appreciated. Regards, Nitin Mahajan
