Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 04-28-2011, 03:33 AM   #1
convexdezign
Junior Member
convexdezign began at the beginning.
 
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
convexdezign is offline   Reply With Quote
Old 04-28-2011, 03:47 AM   #2
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 9,864
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
Is your database on a local drive or on the Network or external USB drive?
DoctorOhh is offline   Reply With Quote
Advert
Old 04-28-2011, 03:53 AM   #3
convexdezign
Junior Member
convexdezign began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Apr 2011
Device: Galaxy Tab
Local drive ESataII.
convexdezign is offline   Reply With Quote
Old 04-28-2011, 04:02 AM   #4
convexdezign
Junior Member
convexdezign began at the beginning.
 
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?
convexdezign is offline   Reply With Quote
Old 04-28-2011, 04:05 AM   #5
kiwidude
calibre/Sigil Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,588
Karma: 2089838
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.
kiwidude is offline   Reply With Quote
Advert
Old 04-28-2011, 04:11 AM   #6
convexdezign
Junior Member
convexdezign began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Apr 2011
Device: Galaxy Tab
@kiwidude: Ok. Thanks. I will try this.

Any other suggestions?
convexdezign is offline   Reply With Quote
Old 04-28-2011, 04:22 AM   #7
kiwidude
calibre/Sigil Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,588
Karma: 2089838
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
Quote:
Originally Posted by convexdezign View Post
@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.
kiwidude is offline   Reply With Quote
Old 04-28-2011, 04:34 AM   #8
convexdezign
Junior Member
convexdezign began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Apr 2011
Device: Galaxy Tab
OK. I'll try this this evening.
Thanks.
convexdezign is offline   Reply With Quote
Old 04-28-2011, 02:00 PM   #9
convexdezign
Junior Member
convexdezign began at the beginning.
 
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.
convexdezign is offline   Reply With Quote
Old 04-28-2011, 03:10 PM   #10
drMerry
Addict
drMerry has become one with the cosmosdrMerry has become one with the cosmosdrMerry has become one with the cosmosdrMerry has become one with the cosmosdrMerry has become one with the cosmosdrMerry has become one with the cosmosdrMerry has become one with the cosmosdrMerry has become one with the cosmosdrMerry has become one with the cosmosdrMerry has become one with the cosmosdrMerry has become one with the cosmos
 
drMerry's Avatar
 
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.
drMerry is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 07:16 AM.


MobileRead.com is a privately owned, operated and funded community.