On 1/16/06, Jeroen Ruigrok van der Werven <[EMAIL PROTECTED]> wrote: > On 1/16/06, nikki <[EMAIL PROTECTED]> wrote: > > Ok your take is appreciated since it is somewhat different then the > > common mis?understanding. The common lore on MySQL is that its good > > enof for Google, Yahoo, Amazon so its a contender. > > SQLite I'm told does not support concurrent users very well. > > Haven't noticed much problems with that using Trac and SQLite. :)
>From http://www.sqlite.org/faq.html#q7 "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." So... concurrency for reading? Yes, so long as nothing's trying to write to the DB file. Concurrency for writing? Nope. -- "May the forces of evil become confused on the way to your house." -- George Carlin
