Kobo Desktop Performance

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.

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

Deleted

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.

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 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, 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.

05-06-2010, 01:37 AM	#1
PeterT Grand Sorcerer Posts: 12,756 Karma: 75000002 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	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, 02:04 AM	#2
george.talusan Kobo Developer Intern Posts: 84 Karma: 253043 Join Date: Apr 2010 Location: Toronto, ON Device: Kobo Touch, Kobo Mini, Kobo Glo	Deleted Last edited by george.talusan; 10-26-2010 at 12:34 PM. Reason: Deleted

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

05-06-2010, 10:25 AM	#3
TallMomof2 Kindlephilia Posts: 2,017 Karma: 1139255 Join Date: Nov 2007 Location: Snowpacolypse 2010 Device: Too many to count	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.

05-07-2010, 03:37 AM	#4
PeterT Grand Sorcerer Posts: 12,756 Karma: 75000002 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	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, 01: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.

Advert

Advert