Re: [sqlite] How to implement connection pooling

thanks for the reply But i have some clarifications though... I downloaded System.Data.SQLite Dll from the website u mentioned but i was clearly stated that i was for Win32 systems.. ie for WIndows OS only... And i am using Linux. So is there a release for linux also? correct me if i am

Re: [sqlite] How to implement connection pooling

We use connection pooling. It took only a few lines of C code to implement. In our case we maintain a global list of open connections and access them by pathname. A mutex is required to protect the list anchor pointer when a new connection is added. We also add pthread read/write locking

RE: [sqlite] How to implement connection pooling

If you're using a recent version of MONO then I assume you're using System.Data.SQLite from Robert Simpson which is now bundled with MONO, right? I use a custom version of the same provider which has connection pooling implemented in the wrapper. We've found it to be a huge performance