SQLite Forum

PRAGMA INTEGRITY_CHECK takes very long
Login
It is very strange indeed. Before I went to bed I started the command two times sequentially. The first gave:
real    52m49.51s
user    10m11.98s
sys     6m37.97s
perc    31.86

and the second:
real    17m7.79s
user    10m14.76s
sys     6m5.03s
perc    95.33

The first took three times as much real time, but the spend time is about the same.


So in the morning I thought lets do it multiple times with:
    for i in $(seq 7) ; do

After more as three hours it was still busy with the first one. So I cancelled it and started it anew and got:
real    20m48.56s
user    10m17.09s
sys     6m13.42s
perc    79.33


real    17m25.53s
user    11m8.20s
sys     6m15.04s
perc    99.78


real    17m26.89s
user    11m9.30s
sys     6m15.26s
perc    99.78


real    16m29.56s
user    10m23.10s
sys     6m4.68s
perc    99.82


real    15m40.67s
user    9m40.58s
sys     5m58.60s
perc    99.84


real    16m11.05s
user    10m5.58s
sys     5m55.47s
perc    98.97


real    16m19.01s
user    10m6.34s
sys     5m58.08s
perc    98.51


I am starting to wonder if there is a problem with my system. :'-(