When performing a lot of queries in a short time span, I have noticed that it takes quite a bit of time (delay) before some queries are executed. Based on my testing, it seems that some queries are put in a queue and are开发者_如何学运维 therefore delayed.
Basically, I am working with two types of queries: (1) queries that need to be executed as quick as possible (they are linked to a timeout timer that cancels the operation when it takes to long) and (2) queries that are executed in the background in an automated way (and over which I have less control).
Is there a way to gain more control over the process of which query gains priority? Can I make sure (using SQLite) that the type 1 queries are executed when they come in and the type 2 queries are put on hold (until the type 1 queries are finished)?
For your information, I am using Gus Mueller's FMDB wrapper to interface with SQLite.
精彩评论