Re: [sqlite] Optimizing Application - SQLite Connection Creation/Sharing

2007-11-24 Thread John Stanton
Cache your open connections. Keep your list in most recently used order and use the most recently used to maximize cache availability. Sabyasachi Ruj wrote: I have an application that uses SQLite extensively. In a part of that application, I need to do the following steps:- 1. I need

Re: [sqlite] Optimizing Application - SQLite Connection Creation/Sharing

2007-11-23 Thread Trevor Talbot
On 11/23/07, Sabyasachi Ruj <[EMAIL PROTECTED]> wrote: > I have an application that uses SQLite extensively. > In a part of that application, I need to do the following steps:- > 1. I need to create a thread per request basis. > 2. Open SQLite connection. > 3. Then