Increase Performance of Edit/Assign to Tags

convexdezign · 04-28-2011, 03:33 AM

Hi,
is there any way to increase the Perfomance on Editing, Renaming, Sorting and Assigning to Tags?
I have over 40K Dokuments in Calibre. The DB File is 28MB.
The VirusScan is turned of. OP is WinXP 32Bit on 64Bit DualCore.
Editing one Book takes 10 Seconds. Assigning 10 Books to a Tag takes 20-25 Seconds.

Is there any Idea to Speed up?

greeting from germany
Jens

DoctorOhh · 04-28-2011, 03:47 AM

Is your database on a local drive or on the Network or external USB drive?

convexdezign · 04-28-2011, 03:53 AM

Local drive ESataII.

convexdezign · 04-28-2011, 04:02 AM

Can i seperate the Database-file from the rest of the FileStructure?
Like putting the DB-File on an SSD?

kiwidude · 04-28-2011, 04:05 AM

Hide the tag browser if you don't already. I find that it is the recalculation of that and sorting which cause the lag, not the writing to the database itself.

convexdezign · 04-28-2011, 04:11 AM

@kiwidude: Ok. Thanks. I will try this.

Any other suggestions?

kiwidude · 04-28-2011, 04:22 AM

Quote:

Originally Posted by convexdezign

@kiwidude: Ok. Thanks. I will try this.

Any other suggestions?

Split your database. Maybe only temporarily while you fix up your metadata if there isn't a natural useful split in the types of books you have. Calibre with a small database is like night and day versus calibre with a large database. Use copy to library to move the books between databases to then edit them in the smaller one.

convexdezign · 04-28-2011, 04:34 AM

OK. I'll try this this evening.
Thanks.

convexdezign · 04-28-2011, 02:00 PM

Ok. I tried to hide the Tag-Browser. But it doesnt bring much more speed.

2 Seconds to Open the Edit-Window.
7 Second to write back a Single Edit.
17 Seconds to multiEdit 3 books and assign a tag.
5 Seconds to delete a book.
:-/

Now i backup the library and try to split into 2 or more libraries. Perhaps it will be faster then.

I think it is the number of Book wich decreases the performance so much.

drMerry · 04-28-2011, 03:10 PM

Also do the following:

On the library menu, say Check library.
This will compact your db.

(Do this often if you change your db-info regular)
A lot of extra info is kept in the db also when it is removed from your library. This is not a calibre bug, it is a performance-boost option for this type of db. You do not have to remove info from the db so it is fast. But if you change a lot of info, your trash-data becomes bigger and that will cause loss of performance in time.

04-28-2011, 03:33 AM	#1
convexdezign Junior Member Posts: 6 Karma: 10 Join Date: Apr 2011 Device: Galaxy Tab	Increase Performance of Edit/Assign to Tags Hi, is there any way to increase the Perfomance on Editing, Renaming, Sorting and Assigning to Tags? I have over 40K Dokuments in Calibre. The DB File is 28MB. The VirusScan is turned of. OP is WinXP 32Bit on 64Bit DualCore. Editing one Book takes 10 Seconds. Assigning 10 Books to a Tag takes 20-25 Seconds. Is there any Idea to Speed up? greeting from germany Jens

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bulk metada edit error trying to edit tags	Purple Lady	Calibre	8	02-17-2011 06:09 PM
Suggestion: Remove all tags button in the bulk edit screen	Daemon	Calibre	3	08-23-2010 06:58 AM
Edit tags of books on Ipod Touch?	abrizz	Apple Devices	1	03-13-2010 04:23 PM
PRS-900 How do I edit the tags with Calibre for the books on the reader	ebook_wv	Sony Reader	8	02-27-2010 05:04 AM
RFE: Remove remove tags in bulk edit	magphil	Calibre	0	08-11-2009 10:37 AM

04-28-2011, 03:47 AM	#2
DoctorOhh US Navy, Retired Posts: 9,889 Karma: 13806776 Join Date: Feb 2009 Location: North Carolina Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen	Is your database on a local drive or on the Network or external USB drive?

04-28-2011, 03:53 AM	#3
convexdezign Junior Member Posts: 6 Karma: 10 Join Date: Apr 2011 Device: Galaxy Tab	Local drive ESataII.

04-28-2011, 04:02 AM	#4
convexdezign Junior Member Posts: 6 Karma: 10 Join Date: Apr 2011 Device: Galaxy Tab	Can i seperate the Database-file from the rest of the FileStructure? Like putting the DB-File on an SSD?

04-28-2011, 04:05 AM	#5
kiwidude Calibre Plugins Developer Posts: 4,720 Karma: 2197770 Join Date: Oct 2010 Location: Australia Device: Kindle Oasis	Hide the tag browser if you don't already. I find that it is the recalculation of that and sorting which cause the lag, not the writing to the database itself.

04-28-2011, 04:11 AM	#6
convexdezign Junior Member Posts: 6 Karma: 10 Join Date: Apr 2011 Device: Galaxy Tab	@kiwidude: Ok. Thanks. I will try this. Any other suggestions?

04-28-2011, 04:34 AM	#8
convexdezign Junior Member Posts: 6 Karma: 10 Join Date: Apr 2011 Device: Galaxy Tab	OK. I'll try this this evening. Thanks.

04-28-2011, 02:00 PM	#9
convexdezign Junior Member Posts: 6 Karma: 10 Join Date: Apr 2011 Device: Galaxy Tab	Ok. I tried to hide the Tag-Browser. But it doesnt bring much more speed. 2 Seconds to Open the Edit-Window. 7 Second to write back a Single Edit. 17 Seconds to multiEdit 3 books and assign a tag. 5 Seconds to delete a book. :-/ Now i backup the library and try to split into 2 or more libraries. Perhaps it will be faster then. I think it is the number of Book wich decreases the performance so much.

04-28-2011, 03:10 PM	#10
drMerry Addict Posts: 293 Karma: 21022 Join Date: Mar 2011 Location: NL Device: Sony PRS-650	Also do the following: On the library menu, say Check library. This will compact your db. (Do this often if you change your db-info regular) A lot of extra info is kept in the db also when it is removed from your library. This is not a calibre bug, it is a performance-boost option for this type of db. You do not have to remove info from the db so it is fast. But if you change a lot of info, your trash-data becomes bigger and that will cause loss of performance in time.

Advert

Advert