Ok. Thank you for your explanation everyone and for being patient with me. I look forward to Sqlite4 in whatever features you implement :)
On Mon, Nov 11, 2013 at 8:17 PM, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Nov 11, 2013 at 1:40 AM, Raheel Gupta <raheel...@gmail.com> wrote: > > > > > I guess a Row level locking could be difficult but a Page Level locking > > could be not that difficult. > > > > In an anomaly-free system, page level locking is not difficult. The > difficulty comes when you have to recover from an application crash (due to > a bug or a "kill -9" or a power loss or some other cause) that occurs in > the middle of updating the page. > > In a client/server database engine, you have a central server that can keep > track of page (or row) locks efficiently. Doing the same in a serverless > system like SQLite is rather more difficult and (as far as I can determine) > requires debilitating run-time overhead. > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > 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
