Kobo Desktop Performance

PeterT · 05-06-2010, 12: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.

george.talusan · 05-06-2010, 01:04 AM

Deleted

TallMomof2 · 05-06-2010, 09: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.

PeterT · 05-07-2010, 02: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 http://www.sqlitecompare.com/ 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:
content
and
volume_shortcovers

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

JPandDee · 05-07-2010, 12: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.

05-06-2010, 12:37 AM	#1
PeterT Wizard Posts: 4,196 Karma: 31946954 Join Date: Nov 2007 Location: Toronto Device: Wifi (mine); Touch (wife + mine); iTouch (wife)	Kobo Desktop Performance 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.

05-06-2010, 01:04 AM	#2
george.talusan Kobo Developer Intern Posts: 77 Karma: 215747 Join Date: Apr 2010 Location: Toronto, ON Device: Kobo Touch, Kobo Mini, Kobo Glo	Deleted Last edited by george.talusan; 10-26-2010 at 11:34 AM. Reason: Deleted

05-06-2010, 09:25 AM	#3
TallMomof2 Kindlephilia Posts: 1,951 Karma: 1041343 Join Date: Nov 2007 Location: Snowpacolypse 2010 Device: Amazon K4, Fire, Droid 2	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. __________________ You make it, we break it.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Kobo Desktop App for XP	gmedin	Kobo Reader	19	12-28-2010 01:44 PM
Over trying to manage Kobo reader with Kobo desktop. Some help with Calibre?	digital_steve	Calibre	14	09-18-2010 01:12 AM
Updated Kobo Desktop	leighisme	Kobo Reader	4	09-10-2010 12:18 PM
Over trying to manage Kobo reader with Kobo desktop. Some help with Calibre?	digital_steve	Kobo Reader	11	08-02-2010 10:31 PM
Using Kobo Desktop issues...	clicker666	Kobo Reader	6	06-29-2010 04:21 PM

05-07-2010, 02:37 AM	#4
PeterT Wizard Posts: 4,196 Karma: 31946954 Join Date: Nov 2007 Location: Toronto Device: Wifi (mine); Touch (wife + mine); iTouch (wife)	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 http://www.sqlitecompare.com/ 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: content and volume_shortcovers I think tomorrow I will reset the device and experiment further (as long as I can steal it away from the wife's fingers).

05-07-2010, 12:55 PM	#5
JPandDee Junior Member Posts: 1 Karma: 10 Join Date: May 2010 Device: KOBO	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.


Advertisement Enthusiast