RE: [sqlite] How to implement connection pooling

ssionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Dinesh Ramdass [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 12:51 PM To: sqlite-users@sqlite.org Subject:

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 wro

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 to

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 improveme