Hi, It is my understanding, per http://www.hwaci.com/sw/sqlite/sharedcache.html section 2.1, that only one write transaction may exist while in shared cache mode. Is that correct?
If so, then I am trying to figure out what is the advantage of having table level locks in shared cache mode. If only one write transaction can be pending at a time, irrespective of the table, then what advantage is there to having table level locks? To put it another way, is there anything gained in terms of concurrency by using shared cached mode versus not using it? BTW, I am not interested in reading uncommitted data. Thanks in advance, Nicolas Rivera _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
