On Thu, 6 May 2004 [EMAIL PROTECTED] wrote: > >I would like to use SQLite on a web server or .net remoting and >multi-user/threads may become an issue >as locking is based at the finest granularity of file locking instead of >table/page/row locking. Will this issue be resolved from 3.x onwards so that >concurrency can be increased when multiple users >are connecting to the db? >SQLite is extremely fast in single process/thread mode and because of this >success, more users would like to access the application. File locking is >too similar to MS Access and we have had all kinds of problems >supporting multiple users on a network drive. Ideally I would first like to >implement SQLite as part of an ISAPI dll so it could be accessed using http >to an IIS web server. >Any suggestions or solutions to running SQLite in multi-threaded environment >with potentially high concurrency???
SQLite already supports concurrent readers. If most access is read only, and writes are short and/or infrequent, then SQLite might continue to fit the bill. But, use the right tool for the job. If you require concurrent readers/writer(s), then you may be better off using a full blown client/server database, especially in a distributed environment. SQLite is designed to be embedded, don't just use it because you can. I believe there may be some work in 3.0 to allow concurrent readers with single writer, but that is likely to be within a single address space only, if at all. >B.Thomas > >-----Original Message----- >From: D. Richard Hipp [mailto:[EMAIL PROTECTED] >Sent: Tuesday, May 04, 2004 1:56 PM >To: [EMAIL PROTECTED] >Subject: Re: [sqlite] release 14 > > >aducom wrote: >> Hi, >> >> Is it possible to do a release 14 of the sqlite.dll with the support of >> real blobs? (It's available in cvs?) Or will I have to wait for the >> full new version? >> > >I don't know what you mean by "support for real blobs". You'll need >to be much more specific. > >Generally speaking, no new features will be added to SQLite 2.8.13. >What you see is what you get. New features go into SQLite 3.0.0. > -- /"\ \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
