What strategies will not solve the lock table? I won't be a sqlite database data to don't lock my query table multi-threaded cases query to lock table.

Such as SELECT COUNT (Guid) for lock table plus the where conditions lead to lock table.


And sqlite database corruption often.. The database disk image is malformed sqlite feeling too much big problem.