On 5/1/15, Jean-Marie CUAZ <jm.cuaz at orens.fr> wrote: > Hello, > > We use Sqlite + Tcl/Tk in a payroll application and everything works > great at high speed ! > > In this application, "PRAGMA quick_check" are processed in a few places > as a security measure : > - before processing backup/restore operations. > - during the process of login into the application. > > The size of a database file for an instance of our application vary from > 100 MB to 700 MB. > > With a "PRAGMA quick_check" processed when login into the application, > the waiting time can reach one minute on an average computer (3 Ghz + > 7200 rpm HD). > > So I ask this naive question : except if already done, could it be > possible to leverage information gathered by Sqlite with "PRAGMA > threads" to process "PRAGMA quick_check" in a multi-threaded manner ? >
Is it CPU bound or I/O bound? I'm guessing the latter, in which case all the threads in the world will not make it run any faster. The latest trunk version of SQLite has change to reduce the CPU usage in PRAGMA quick_check, if you want to experiment with that to see if it helps. -- D. Richard Hipp drh at sqlite.org
