View Single Post
Old 03-24-2013, 05:01 AM   #6
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,779
Karma: 30237628
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Adoby View Post
It is already there.

Use {:'approximate_formats()'} instead of {formats}, and everything should be fine. At least if you only use calibre to delete or add book formats. Then approximate_formats() will retrieve the existing formats from the db, without any need to actually check the actual books.
Thanks Adoby I didn't know about that, just added the column and happy to report that my database approx-formats accords 100% with the actual files, but...

When I removed the Formats column (see earlier post) my scroll bar stickiness disappeared, which 'made sense' - no need to interrogate folder contents.

So I turned computer off and went to lunch happy in the knowledge that my sticky scroll button niggle had been resolved/explained away.

When I came back I reinstated the Formats column and... the scroll bar stickiness did not come back, and... wait for it... sort on Formats column (theDucks, that's why I have it) on the whole library (20,000+ books) was almost instantaneous - it used to be a minute or two.

Maybe everything is 'cached', maybe my virus scanner is making Calbre faster, maybe I inadvertently hijacked the NSA computers. Own up Kovid, what did you do :lol:

its probably Heisenberg, or Eisenstein.

BR
BetterRed is online now   Reply With Quote