On Mon, Nov 11, 2013 at 1:40 AM, Raheel Gupta <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
