Kobo Desktop Performance
#1  PeterT 05-06-2010, 01:37 AM
To be nice to my wife, I downloaded all the free romance books from the Kobo Store. Many of these are NOT in ePub format; but rather the propietary Kobo format and get stored in the SQLite Database.

The act of dropping one done on the PC (ie delete on web site, Update the Kobo Desktop, Sync to Kobo) is quick.

However; the processing done on the Kobo when the USB cable is disconnected is atrocious! I would swear it took 10 to 15 minutes just now to complete that process. and that was only dropping a single book.

Currently the .kobo\KoboReader.sqlite database on the Kobo is 112,378,880 bytes.

#2  george.talusan 05-06-2010, 02:04 AM

#3  TallMomof2 05-06-2010, 10:25 AM
I bet it's because of the books in the proprietary Kobo format. All of the contents not just metadata is added to the database. It must take a lot of extra time to process the book contents in the database.

#4  PeterT 05-07-2010, 03:37 AM
Interesting... I just tried an experiment. Before doing a Sync from the PC to the Kobo I saved a copy of the database from the Kobo to my PC.

Then I did the Sync but did not disconnect the Kobo, and then grabbed another copy of the database.

Using a free tool SQLite Compare I compared the two databases.

It would appear the Kobo Desktop client DELETED the data for the majority of ePub format books that had been added via ADE.

Then I did the disconnect, and let the Kobo go through a roughly 15 minute process of updates, and again reconnected the Kobo and copied the database.

The entries that were dropped were now re-added.

The only tables changed during this process were:

I think tomorrow I will reset the device and experiment further (as long as I can steal it away from the wife's fingers).

#5  JPandDee 05-07-2010, 01:55 PM
A significant part of the Sync process is one-time initiation in addition to the transfer of the book. I transferred 10 books the other day and it only took about 3 times as long as transferring 1.

Whenever KOBO starts releasing reader firmware upgrades, that will have an impact as well.

Today's Posts | Search this Thread | Login | Register