The pragma integrity_check is still running... Maybe my disk sucks for some reason?
The output of iostat looks normal to me though.. $ iostat -dmN encplate 1 5 Linux 4.1.4-1-ARCH (slyrogue) 08/17/2015 _x86_64_ (8 CPU) Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn encplate 151.63 6.93 4.35 225847 141971 Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn encplate 111.00 7.80 0.07 7 0 Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn encplate 158.00 10.29 0.47 10 0 Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn encplate 110.00 8.43 0.07 8 0 Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn encplate 131.00 11.36 0.00 11 0 On Mon, Aug 17, 2015 at 4:28 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 17 Aug 2015, at 8:17am, Simon Slavin <slavins at bigfraud.org> wrote: > >> Also, out of interest, can you run "PRAGMA integrity_check" on all the >> database files involved ? > > Also out of interest, instead of just ATTACHing the input database, > > 1) Close the output database > 2) Reopen the output database > 3) ATTACH the input database > > Does it take the same amount of time ? If so, which step takes the time ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
