Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 02-10-2010, 10:29 PM   #1
Sabardeyn
Fanatic
Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.
 
Sabardeyn's Avatar
 
Posts: 552
Karma: 1239646
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.
Sabardeyn is offline   Reply With Quote
Old 02-10-2010, 11:21 PM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 24,765
Karma: 4369667
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.
kovidgoyal is offline   Reply With Quote
 
Enthusiast
Old 02-11-2010, 06:45 PM   #3
Sabardeyn
Fanatic
Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.
 
Sabardeyn's Avatar
 
Posts: 552
Karma: 1239646
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
Sabardeyn is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 03:13 AM.


MobileRead.com is a privately owned, operated and funded community.