Since SLQite was never intended for multi user databases in the initial design i.e. the name "SQLite" I would say the design is the reason.
Now can the design be reengineered to allow finer grain locking as an option without derailing the original design intent? That is for those that do all the work for the rest of us to decide. My only incentive that pops readily to mind would be the enormous bandwidth reduction here with no further need to ask and answer, "Will SQLite support mulit users? and etc. ad nauseium..." :-) Fred -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of CityDev Sent: Friday, September 25, 2009 12:58 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite Suitability for Shopping Cart This is what is says on the SQLite site: "We are aware of no other embedded SQL database engine that supports as much concurrency as SQLite. SQLite allows multiple processes to have the database file open at once, and for multiple processes to read the database at once. When any process wants to write, it must lock the entire database file for the duration of its update. But that normally only takes a few milliseconds. Other processes just wait on the writer to finish then continue about their business. Other embedded SQL database engines typically only allow a single process to connect to the database at once." What that seems to be saying is you can have concurrency but you will suffer the effects of whole-database locking for update transactions. It seems a glaring shortcoming, so either SQLite is not normally used by multiple processes or people find it doesn't matter too much ie you still get acceptable performance with n users. Which do you think is true? -- View this message in context: http://www.nabble.com/SQLite-Suitability-for-Shopping-Cart-tp25530589p256068 92.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
