Very slow database writes

LessPaul · 08-02-2009, 10:17 PM

I'm giving Calibre a try today. After a few hours my library of 7500 books were imported -- sadly about 1/2 of them have the authors and titles reversed.

I see an upcoming patch will make the edits less painful.

However, the problem I am having at the moment are very slow database writes.

If I open a single entry and make a change, saving back to the database is about six seconds.

Metadata in bulk is much worse. I selected 10 records to correct the spelling of the author's name. I then selected "Edit metadata in bulk" and made my change. However, when I clicked "OK" it was a full two minutes before the changes were displayed and the GUI was again responsive.

I am running Vista 64 with four gig of memory on a 2.8ghz Quad-core.

Given the size of my library, these delays are a show-stopper as I had hoped to use the tool to quickly organize my books and enter metadata.

Any tips or advice much appreciated.

itimpi · 08-03-2009, 01:14 AM

What format are most of the books?

Are you using a network drive? That is known to be slow.

caluser · 08-03-2009, 07:37 AM

I have encountered the same issue with OSX 10.5.7 and running latest Calibre 0.6.4.

what used to take seconds earlier takes minutes or even hours (I left it running to check out how long it would go). I usually quit Calibre and restart the transfer which usually fixes it. But it still takes long to process.

My books are all pdf.

Ralob · 08-03-2009, 09:56 AM

Quote:

Originally Posted by caluser

I have encountered the same issue with OSX 10.5.7 and running latest Calibre 0.6.4.

what used to take seconds earlier takes minutes or even hours (I left it running to check out how long it would go). I usually quit Calibre and restart the transfer which usually fixes it. But it still takes long to process.

My books are all pdf.

That is because calibre is trying to get the metadata for the PDF. To make things go faster, goto: preferences -> plugins -> metadata reader, and disable the PDF plugin. Everything should go much more smooth.

LessPaul · 08-03-2009, 10:51 AM

Quote:

What format are most of the books?

In order of frequency: pdf, palm doc, mobi, html and word.

Quote:

Are you using a network drive? That is known to be slow.

No.

Quote:

That is because calibre is trying to get the metadata for the PDF. To make things go faster, goto: preferences -> plugins -> metadata reader, and disable the PDF plugin. Everything should go much more smooth.

I tried that, and also tried disabling the PDF metadata writer (since my troubles are on write, not read). Neither made a positive difference.

08-02-2009, 10:17 PM	#1
LessPaul Connoisseur Posts: 50 Karma: 160 Join Date: Jan 2008 Location: Dewitt, MI Device: Kindle Paperwhite 2021 / PC / iPad	Very slow database writes I'm giving Calibre a try today. After a few hours my library of 7500 books were imported -- sadly about 1/2 of them have the authors and titles reversed. I see an upcoming patch will make the edits less painful. However, the problem I am having at the moment are very slow database writes. If I open a single entry and make a change, saving back to the database is about six seconds. Metadata in bulk is much worse. I selected 10 records to correct the spelling of the author's name. I then selected "Edit metadata in bulk" and made my change. However, when I clicked "OK" it was a full two minutes before the changes were displayed and the GUI was again responsive. I am running Vista 64 with four gig of memory on a 2.8ghz Quad-core. Given the size of my library, these delays are a show-stopper as I had hoped to use the tool to quickly organize my books and enter metadata. Any tips or advice much appreciated.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
E-book writes its 2nd chapter, ITnews AU	sabredog	News	4	01-08-2010 05:59 PM
Bev Vincent writes like a girl	Nate the great	Writers' Corner	4	08-01-2009 08:45 PM
calibre - very slow conversion, very slow on PRS	cremofix	Calibre	3	06-10-2009 04:21 PM
CEO of a top 10 book publisher writes about e-books	Bob Russell	News	4	05-20-2009 09:04 AM
Nobel Prize winner writes on-line book	ath	Deals and Resources (No Self-Promotion or Affiliate Links)	8	05-04-2008 10:51 PM

08-03-2009, 01:14 AM	#2
itimpi Wizard Posts: 4,553 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	What format are most of the books? Are you using a network drive? That is known to be slow.

08-03-2009, 07:37 AM	#3
caluser Junior Member Posts: 3 Karma: 10 Join Date: Aug 2009 Device: PRS-505	I have encountered the same issue with OSX 10.5.7 and running latest Calibre 0.6.4. what used to take seconds earlier takes minutes or even hours (I left it running to check out how long it would go). I usually quit Calibre and restart the transfer which usually fixes it. But it still takes long to process. My books are all pdf.

Advert

Advert