[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

2015-05-03 Thread Jean-Marie CUAZ
To reply to Mr. Slavin > In any properly working system even integrity-check (more thorough than quick-check) never fails, and > neither should be necessary in anything except a rarely-used maintenance procedure. They are both > diagnostic tools for faults, not part of a smoothly running

[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

2015-05-02 Thread Simon Slavin
On 2 May 2015, at 12:14pm, Jean-Marie CUAZ wrote: > Yes, a few years ago on a test db, used for developpment and testing purpose, > "PRAGMA quick_check" reported some anomalies I would not continue to use any system which occasionally caused quick_check -- or more importantly integrity-check

[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

2015-05-02 Thread Jean-Marie CUAZ
Thank you for your answers. To reply to Mr. Hipp and Mr. Morras : Yes your are right, verifications made, the process is I/O bound. (CPU activity jumps from 1% - 2% at iddle time to 5-6 % when a "PRAGMA quick_check" is processed). Thank you for pointing to me the right track ! About

[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

2015-05-01 Thread Simon Slavin
On 1 May 2015, at 4:58pm, Jean-Marie CUAZ wrote: > 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. Answers you've already received are more

[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

2015-05-01 Thread Eduardo Morras
On Fri, 01 May 2015 17:58:06 +0200 Jean-Marie CUAZ 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

[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

2015-05-01 Thread Jean-Marie CUAZ
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.

[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

2015-05-01 Thread Richard Hipp
On 5/1/15, Jean-Marie CUAZ 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. > -