MobileRead Forums - View Single Post

audeojude · 10-30-2011, 12:54 PM

ok I changed the path to include the metadata.db and it worked.
so it would read like this

export CALIBRE_OVERRIDE_DATABASE_PATH="/home/scott/metadata.db"

I can tell that the database is being addressed and written to faster however the lag before the infterface is available is still around 20 seconds. Actually it feels just a hair longer.

I just added twenty books to the library and the dialog that shows them being added was much quicker. After it said they were added though, the time for the interface to become available was still about the same as before.

I then did a could of bulk metadata edits. One to change author name and another to add and then another to delete tags. These seemed to happen really quickly in the interface that shows progress compared to before. After that though the main interface took about 22 seconds to become responsive again.

So I think the database portion is running faster. However I am now going to say that I/O to it is not what was causing the unwieldy lag in the interface that I was complaining of.

I was thinking that maybe it was simply the interface trying to list 59000 books when it refreshes but I get the same lag even when there is only 41 entries listed on a search that has limited the return.

I am stumped.. I was so sure that what I was seeing was a I/O issue and it isn't. Moving the database to the ssd did improve I/O to it but that wasn't what was causing the percieved slowness.

If anyone has any ideas about what is causing this I'm open to theorys and stuff to try. I'm not sure how many people out there have that many files stored in calibre but I'm sure that over time more and more will have large libraries. It would be good to figure this out.

I will have to say though that calibre is amazing. Even though I have slow issues it still does the job and waiting 20 seconds isn't the end of the world. The only issue I have ever had with it that is a bug is that when adding a large number of files at one time it will sometimes crash. I just keep it down to smaller groups of books when adding to get around that. usually anything under 300 at a time will do fine. Though I have successfully at 600 and 700 a few time successfully.

I did notice that the ones that crashed felt more like it was the cumulative size of all the files rather than the number of them. Just an unsubstantiated feeling.

10-30-2011, 12:54 PM	#16
audeojude Connoisseur Posts: 80 Karma: 489964 Join Date: Oct 2011 Location: Deep South Device: 4 or 5 generations of kindles	ok I changed the path to include the metadata.db and it worked. so it would read like this export CALIBRE_OVERRIDE_DATABASE_PATH="/home/scott/metadata.db" I can tell that the database is being addressed and written to faster however the lag before the infterface is available is still around 20 seconds. Actually it feels just a hair longer. I just added twenty books to the library and the dialog that shows them being added was much quicker. After it said they were added though, the time for the interface to become available was still about the same as before. I then did a could of bulk metadata edits. One to change author name and another to add and then another to delete tags. These seemed to happen really quickly in the interface that shows progress compared to before. After that though the main interface took about 22 seconds to become responsive again. So I think the database portion is running faster. However I am now going to say that I/O to it is not what was causing the unwieldy lag in the interface that I was complaining of. I was thinking that maybe it was simply the interface trying to list 59000 books when it refreshes but I get the same lag even when there is only 41 entries listed on a search that has limited the return. I am stumped.. I was so sure that what I was seeing was a I/O issue and it isn't. Moving the database to the ssd did improve I/O to it but that wasn't what was causing the percieved slowness. If anyone has any ideas about what is causing this I'm open to theorys and stuff to try. I'm not sure how many people out there have that many files stored in calibre but I'm sure that over time more and more will have large libraries. It would be good to figure this out. I will have to say though that calibre is amazing. Even though I have slow issues it still does the job and waiting 20 seconds isn't the end of the world. The only issue I have ever had with it that is a bug is that when adding a large number of files at one time it will sometimes crash. I just keep it down to smaller groups of books when adding to get around that. usually anything under 300 at a time will do fine. Though I have successfully at 600 and 700 a few time successfully. I did notice that the ones that crashed felt more like it was the cumulative size of all the files rather than the number of them. Just an unsubstantiated feeling.