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 sys
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
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 downloadi
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 i
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 backup
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.
T
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.
> - dur
7 matches
Mail list logo