View Single Post
Old 07-01-2013, 06:43 PM   #13
BetterRed
null operator
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: 3,808
Karma: 2698649
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by epubfan View Post
Hm, then all informations in 1 db-column and searches will be faster or what is the trick?
You wrote you search in title, author, date, size, words, language, format.

With the exception of format, these are database columns, the database is 'heavily indexed' in order to make searching and sorting fast.

However, 'formats' refers to the extensions of files in book folders, hence a search (or sort) must crawl through the library folder tree looking for files whose extensions match the search term, which is slow.

But, 'approximate_formats()' refers to a derived list of formats that you need to put in a custom database column which will be fast for the same reasons other database column based searches are.

See the link that Peter T posted for a discussion of why & how the function came to implemented. And see http://manual.calibre-ebook.com/temp...ximate-formats for definition and caveats

BR
BetterRed is offline   Reply With Quote