Does anybody here knows sqlite internals (especially database file locking algorithm)?
Or am I only one who meet this bug? May be someone could persuade me that it's not a bug? Concerning the problem - I have some table (not so big at my point of view but with 60000 records). I start transaction and delete most of records After this sqlite fails on "select from sqlite_master" (or any other query) because it extend lock level to exclusive lock when deleting records. It reset exclusive lock on transaction commit only. Locking algorithm is different when table holds a few records less I've already posted sqlite trace here. May be there is known limit of how many records one could delete from table or update in single transaction? It is significant that I have single tread plain application.
