Compacting the Database?

Sabardeyn · 02-10-2010, 10:29 PM

Just wondering if, after deleting my entire calibre library, do I need to compact the database in some way? I noticed that any new books I entered began with the next sequential number right before I started deleting.

So, I had, say... 139 books, deleted 139 books, re-entered books in a completely different order - but book numbering began at #140.

While I realize this does not affect calibre per se, I'm just wondering if I missed something.

Edit: I highlighted books and pressed the Del key, I did not use the toolbar trashcan icon. I did still get the Are You Sure dialog though.

kovidgoyal · 02-10-2010, 11:21 PM

That's deliberate. id numbers are never reused. If yo want to force them to be re-used ( abad idea) you can always delete the metadata.db file.

Sabardeyn · 02-11-2010, 06:45 PM

No, that was not my intent. I just thought that I had done something equivalent to the MS Access error of old. (Deleting records, but never compacting the database. So the database file size increased unnecessarily, used unique IDs inefficiently, etc.)

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
portable database?	sn123py	Calibre	28	05-18-2011 04:43 AM
Readonly Database	seanbw	Calibre	6	03-17-2010 06:30 PM
What Database?	LadyLou	Calibre	8	02-12-2010 06:32 AM
iLiad Database on iLiad?	tikitu	iRex Developer's Corner	6	02-17-2009 11:33 AM
new database format	alexxxm	Calibre	10	11-19-2008 03:45 AM

02-10-2010, 10:29 PM	#1
Sabardeyn Guru Posts: 644 Karma: 1242364 Join Date: May 2009 Location: The Right Coast Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)	Compacting the Database? Just wondering if, after deleting my entire calibre library, do I need to compact the database in some way? I noticed that any new books I entered began with the next sequential number right before I started deleting. So, I had, say... 139 books, deleted 139 books, re-entered books in a completely different order - but book numbering began at #140. While I realize this does not affect calibre per se, I'm just wondering if I missed something. Edit: I highlighted books and pressed the Del key, I did not use the toolbar trashcan icon. I did still get the Are You Sure dialog though.

02-10-2010, 11:21 PM	#2
kovidgoyal creator of calibre Posts: 43,860 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	That's deliberate. id numbers are never reused. If yo want to force them to be re-used ( abad idea) you can always delete the metadata.db file.

02-11-2010, 06:45 PM	#3
Sabardeyn Guru Posts: 644 Karma: 1242364 Join Date: May 2009 Location: The Right Coast Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)	No, that was not my intent. I just thought that I had done something equivalent to the MS Access error of old. (Deleting records, but never compacting the database. So the database file size increased unnecessarily, used unique IDs inefficiently, etc.) Thanks

Advert