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

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 07-25-2011, 08:33 AM   #16
phil_ga
Member
phil_ga has a complete set of Star Wars action figures.phil_ga has a complete set of Star Wars action figures.phil_ga has a complete set of Star Wars action figures.
 
Posts: 10
Karma: 280
Join Date: Feb 2011
Device: kindle
Quote:
Originally Posted by itimpi View Post
Any time you change the metadata for a book, the database is updated and the OPF file is also updated. If it was only done when users requested it the object of having it in the first place would be largely defeated. It is meant to allow you to recover from an unpredictable event (database damage) so the OPF files need to be kept as up-to-date as possible.
I will look into this, but i remain unconvinced at this point that it actually changes the opf content rather than the file date.

Quote:
Originally Posted by itimpi View Post
In terms of the performance issue - do you have the "Search as you type" option set under Preferences->Interface->Searching. I could see that severely impacting perceived performance. I much prefer searching to only occur when I press Enter so I always have it switched off. I am not sure what the default is on a new installation.
No I do not have that feature set. ...BUT there is a switch in the same menu called "Limit the search metadata". I tried that. It makes a huge difference to response time when searching direct fromt he search bar with free text! Wow. Thanks for the tip!! Now I will look into the sluggish behaviour in other areas - to see if any of them are also sped up (later - bedtime now...). But this tip is a big help with responsiveness for vanilla searching. Thanks!!!
phil_ga is offline   Reply With Quote
Old 07-25-2011, 12:08 PM   #17
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
I didn't see it here, but has anyone suggested that he exclude the Calibre library from his antivirus? That will sometimes do wonders for Calibre speed problems.

My library is 17K books. My experience is just like chaley's. It's fast and responsive and I've never seen a corrupted database despite running from source and bleeding edge for the last 1.5 years.
Starson17 is offline   Reply With Quote
Old 07-25-2011, 12:33 PM   #18
PeterT
Taking a break; Fed up
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 7,190
Karma: 45329895
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
Also, maybe some hard drive maintenance? A defrag possibly??
PeterT is online now   Reply With Quote
Old 07-25-2011, 12:48 PM   #19
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 15,084
Karma: 5939999
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by PeterT View Post
Also, maybe some hard drive maintenance? A defrag possibly??
Check the: Path variable for reasonableness. Move Calibre forward in the list
here is the path on my XP system. as you can see, Calibre is currently in the lowest position.

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\Program Files\Support Tools\;C:\WINDOWS\system32\WindowsPowerShell\v1.0; C:\Program Files\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\Calibre2\

BTW I have seen systems wit corrupted pats that loop throug the same EXACT folders many times
theducks is offline   Reply With Quote
Old 07-25-2011, 01:52 PM   #20
Censkar
Junior Member
Censkar began at the beginning.
 
Posts: 1
Karma: 10
Join Date: Jul 2011
Device: IPad
I got a library with 13k+ books and I noticed a large slowdown when I updated from 0.8.8 (I tried all three versions .9 .10 and .11) so I had to revert to 0.8.8. Especially at startup. .8 starts in 15-20 seconds but the later versions takes minutes to start.
I checked in task manager at startup and .8 allocates/reads 10 Mb at a time but the later versions allocates/reads kbytes at a time?

Using Win 7 X64 and db on a NAS.

Last edited by Censkar; 07-25-2011 at 01:54 PM. Reason: Forgot hardware specs.
Censkar is offline   Reply With Quote
Old 07-25-2011, 03:50 PM   #21
Pinecone
Guru
Pinecone ought to be getting tired of karma fortunes by now.Pinecone ought to be getting tired of karma fortunes by now.Pinecone ought to be getting tired of karma fortunes by now.Pinecone ought to be getting tired of karma fortunes by now.Pinecone ought to be getting tired of karma fortunes by now.Pinecone ought to be getting tired of karma fortunes by now.Pinecone ought to be getting tired of karma fortunes by now.Pinecone ought to be getting tired of karma fortunes by now.Pinecone ought to be getting tired of karma fortunes by now.Pinecone ought to be getting tired of karma fortunes by now.Pinecone ought to be getting tired of karma fortunes by now.
 
Posts: 893
Karma: 1660722
Join Date: Nov 2009
Location: Maryland
Device: PRS-650, PRS-600, PRS-350
Quote:
Originally Posted by phil_ga View Post
@Chaley - I get nothing like the response times you indicate (apart from the program start time), with similar specc'ed PC (but Vista).
That could be a BIG part of it.
Pinecone is offline   Reply With Quote
Old 07-25-2011, 04:53 PM   #22
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by Pinecone View Post
Quote:
Originally Posted by phil_ga View Post
@Chaley - I get nothing like the response times you indicate (apart from the program start time), with similar specc'ed PC (but Vista).
That could be a BIG part of it.That could be a BIG part of it.
If you're pointing to Vista, I've got nearly identical response times to chaley's with 17K book library on a Vista install.
Starson17 is offline   Reply With Quote
Old 07-25-2011, 08:48 PM   #23
lbik
Reader
lbik doesn't litterlbik doesn't litter
 
Posts: 46
Karma: 162
Join Date: Nov 2010
Location: Hannover
Device: Kindle KB and Kindle Fire HD 8.9
Quote:
My guess is that not searching the comments field will do wonders for you.
Great. It does allso wonders for me.

thanks Chaley.
lbik is offline   Reply With Quote
Old 07-30-2011, 03:11 AM   #24
phil_ga
Member
phil_ga has a complete set of Star Wars action figures.phil_ga has a complete set of Star Wars action figures.phil_ga has a complete set of Star Wars action figures.
 
Posts: 10
Karma: 280
Join Date: Feb 2011
Device: kindle
Quote:
Originally Posted by phil_ga View Post
I will look into this, but i remain unconvinced at this point that it actually changes the opf content rather than the file date.

No I do not have that feature set. ...BUT there is a switch in the same menu called "Limit the search metadata". I tried that. It makes a huge difference to response time when searching direct from the search bar with free text! Wow. Thanks for the tip!! Now I will look into the sluggish behaviour in other areas - to see if any of them are also sped up (later - bedtime now...). But this tip is a big help with responsiveness for vanilla searching. Thanks!!!
Just to summarise the resolution of this problem:
My slow and sluggish calibre is showing consistently faster performance in all areas I previously complained about. itimpi 's tip did the trick!

In the preferences under: Preferences -> Interface -> Searching
Choose: Searching -> Limit the searched metadata
I set my values to: title, authors, series

Not only is searching from the search bar much much zippier, but the sluggishness in other areas, such as editing fields directly also disappears.

Gee, I would think this setting should be "on" out of the box - but then again, not a lot have databases this size (but i am betting there will be more and more).
Thanks calibre, thanks itimpi and jackastor!.
phil_ga is offline   Reply With Quote
Old 07-30-2011, 03:30 AM   #25
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,230
Karma: 1345754
Join Date: Oct 2010
Location: London, UK
Device: Kindle Paperwhite 3G, iPad 3, iPad Air
You might want to add tags to that list, depending on how and if you use them.

Many months ago I was at least one of the original 'complainers' that triggered chaley to add this feature which is a must have setting for me too. My rationale was not for performance reasons, it was to do with the quality of the search results. You no longer have to prefix every search term with the likes of title: etc just to quickly find the book you are after as you no longer get all the false positives from random word matches in comments etc. That this feature also improves performance is just an added bonus to me!

Note that you can still search other fields with your list restricted, you just need to prefix them like comments:xxx
kiwidude is offline   Reply With Quote
Old 07-30-2011, 11:45 AM   #26
transmitthis
Addict
transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.
 
transmitthis's Avatar
 
Posts: 285
Karma: 1003542
Join Date: May 2011
Device: Google Nexus 7 16GB
I always have problems searching - took me ages trying to discover the proper format to do a date search one day. (forgotten it now)

I would like to suggest there is a key modifier added that would automatically put the correct string into the search bar, ready for you to search...

ie,
Ctr+"Author column" (Left click in Column heading)
Would place authors:"="

Ah, wait a mo, I bet thats not possible, and it would leave the curser outside of the " so people would have to remember to type in the right place.

Still there should be a more simple one click way of searching within a particular column without having to remember these search strings with : and "" and = etc., as most users are not going to type that, they are just going to free text search


PS (C2D 3Ghz 4GBRam, Win7,64bit
Calibre starts in:
5 seconds - if the library only contains one book.
with 9000 books
60 seconds to open
14 seconds if its previously been opened, ie still in cache
I know some programs open, while loading required data in the background, to speed up load times.
transmitthis is offline   Reply With Quote
Old 07-30-2011, 11:48 AM   #27
transmitthis
Addict
transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.
 
transmitthis's Avatar
 
Posts: 285
Karma: 1003542
Join Date: May 2011
Device: Google Nexus 7 16GB
Maybe a dropdown list in the search bar, that will limit search to each individual column heading. That way if you want to search authors, it would be click on drop down, select Author, and type.
Anyway just another of my not really code-able suggestions
transmitthis is offline   Reply With Quote
Old 07-30-2011, 12:36 PM   #28
dkelly701
Member
dkelly701 is kind to children and small, furry animalsdkelly701 is kind to children and small, furry animalsdkelly701 is kind to children and small, furry animalsdkelly701 is kind to children and small, furry animalsdkelly701 is kind to children and small, furry animalsdkelly701 is kind to children and small, furry animalsdkelly701 is kind to children and small, furry animalsdkelly701 is kind to children and small, furry animalsdkelly701 is kind to children and small, furry animalsdkelly701 is kind to children and small, furry animalsdkelly701 is kind to children and small, furry animals
 
Posts: 16
Karma: 6620
Join Date: Jan 2011
Device: Nook
Maybe I am missing something here, but isn't there already an easy way to do this by clicking on the "search binoculars" beside the search bar. Click on the Title, Author, Series tab and type in the search criteria. Click on the down arrow at the bottom if you want to search in other data sets.

Quote:
Originally Posted by transmitthis View Post
I always have problems searching - took me ages trying to discover the proper format to do a date search one day. (forgotten it now)

I would like to suggest there is a key modifier added that would automatically put the correct string into the search bar, ready for you to search...

ie,
Ctr+"Author column" (Left click in Column heading)
Would place authors:"="

Ah, wait a mo, I bet thats not possible, and it would leave the curser outside of the " so people would have to remember to type in the right place.

Still there should be a more simple one click way of searching within a particular column without having to remember these search strings with : and "" and = etc., as most users are not going to type that, they are just going to free text search


PS (C2D 3Ghz 4GBRam, Win7,64bit
Calibre starts in:
5 seconds - if the library only contains one book.
with 9000 books
60 seconds to open
14 seconds if its previously been opened, ie still in cache
I know some programs open, while loading required data in the background, to speed up load times.
dkelly701 is offline   Reply With Quote
Old 07-30-2011, 01:53 PM   #29
transmitthis
Addict
transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.
 
transmitthis's Avatar
 
Posts: 285
Karma: 1003542
Join Date: May 2011
Device: Google Nexus 7 16GB
dkelly701 - Er, no your not, I was missing that.. .lol

It only has four column heading to choose from though and would be nice if it was more integrated into the search bar,
Still thanks for the heads up at least some searches will be easier
transmitthis is offline   Reply With Quote
Reply

Tags
database, metadata, metadata.db

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calibre Database cp Kindle Database mitch13 Library Management 1 05-22-2011 08:33 PM
Charging Issues and Screen Issues srj321 Sony Reader 2 07-12-2010 12:52 AM
Database Issues after removing books mobelby Calibre 6 05-31-2009 02:28 AM
Adding books to a large database Student1 Calibre 31 04-07-2009 07:43 PM
Management issues with large databases Student1 Calibre 16 02-20-2009 01:42 PM


All times are GMT -4. The time now is 09:53 PM.


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