Database Integrity Check a speed demon?

DoctorOhh · 12-20-2010, 11:55 PM

I ran the Database Integrity check on my 4300 book library and expected to wait endless minutes while it did its thing. Less then 30 seconds later it was complete.

It still would be nice to have a positive affirmation widow that you had to acknowledge, something like Database Integrity check complete, no errors found.

Great work to everyone for all of the recent speed improvements.

Thanks!

kovidgoyal · 12-21-2010, 12:42 PM

was there a time when the check was particularly slow? I don;t use it often, so I haven't been keeping track.

I'll add the success message for the next release.

theducks · 12-21-2010, 01:50 PM

Quote:

Originally Posted by kovidgoyal

was there a time when the check was particularly slow? I don;t use it often, so I haven't been keeping track.

I'll add the success message for the next release.

Was this check part of the action that happened when we clicked the button in the old "Preferences Miscellaneous" section and later split out? It was not glaringly obvious then, where in the things happening, how long a 'step' took.

kovidgoyal · 12-21-2010, 02:53 PM

yes, it was.

DoctorOhh · 12-21-2010, 06:48 PM

Quote:

Originally Posted by kovidgoyal

was there a time when the check was particularly slow? I don;t use it often, so I haven't been keeping track.

On my machine it seemed slow enough I just stopped trying it. Who knows what caused it, Possibly it was just my perception. Maybe there was a time flux here where I sit.

Point is now it is lightning fast.

Quote:

Originally Posted by kovidgoyal

I'll add the success message for the next release.

Thanks Kovid!

audeojude · 03-18-2013, 10:14 PM

Just weighing in on this.
I just ran the check database in calibre 9.16 on a db file off 166 mb, holding 120000 books in it. On a i7-3770T running at 2.5 ghz, 32 gig of ram and running off of a sata3 3 terrabyte drive with transfer speeds of 100mbs + ( i think read speed is about 140mbs) It took about 4 minutes.

12-20-2010, 11:55 PM	#1
DoctorOhh US Navy, Retired Posts: 9,897 Karma: 13806776 Join Date: Feb 2009 Location: North Carolina Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen	Database Integrity Check a speed demon? I ran the Database Integrity check on my 4300 book library and expected to wait endless minutes while it did its thing. Less then 30 seconds later it was complete. It still would be nice to have a positive affirmation widow that you had to acknowledge, something like Database Integrity check complete, no errors found. Great work to everyone for all of the recent speed improvements. Thanks!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Check Database Integrity - Error	ZakM	Calibre	2	09-06-2010 03:20 AM
Error: Failed to check database integrity in v0.7.16	irrationalJohn	Calibre	6	08-29-2010 02:31 PM
Error on Check Database Integrity	Filigree	Calibre	1	01-09-2010 01:21 AM
[Error] Check the integrity of the database	simonbcn	Calibre	0	08-30-2009 12:11 PM
Integrity Check	earthq	Calibre	3	06-17-2009 12:20 PM

12-21-2010, 12:42 PM	#2
kovidgoyal creator of calibre Posts: 45,598 Karma: 28548962 Join Date: Oct 2006 Location: Mumbai, India Device: Various	was there a time when the check was particularly slow? I don;t use it often, so I haven't been keeping track. I'll add the success message for the next release.

12-21-2010, 02:53 PM	#4
kovidgoyal creator of calibre Posts: 45,598 Karma: 28548962 Join Date: Oct 2006 Location: Mumbai, India Device: Various	yes, it was.

03-18-2013, 10:14 PM	#6
audeojude Connoisseur Posts: 80 Karma: 489964 Join Date: Oct 2011 Location: Deep South Device: 4 or 5 generations of kindles	Just weighing in on this. I just ran the check database in calibre 9.16 on a db file off 166 mb, holding 120000 books in it. On a i7-3770T running at 2.5 ghz, 32 gig of ram and running off of a sata3 3 terrabyte drive with transfer speeds of 100mbs + ( i think read speed is about 140mbs) It took about 4 minutes.

Advert

Advert