开发者

Query priority in SQLite

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜