View Single Post
Old 10-03-2020, 10:52 AM   #35
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,465
Karma: 8025600
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by compurandom View Post
The part of the original objection to this was that the columns cache calculated values. I figure that some templates are no worse than pulling the cached value, but have you noticed a performance difference with others?
I haven't noticed a performance difference because my library is too small. That said, I came to the conclusion that the composite column cache doesn't help enough to justify not adding the feature. When searching the cache is per book, so it helps only if a composite column is referenced directly or indirectly more than once in a query.

EDIT: What I said above is misleading. The cache is initialized for a book the first time that book is referenced, either in a search or by being displayed. It is cleared when data changes for a book. Thus repeated searches using non-template field references will use the cache.
Quote:
Also, I've noticed that I can't sort one of my columns built from other columns, which makes me doubt how much caching is going on.
This usually happens when the search/sort type set in the column definition doesn't match the what the template produced.

Last edited by chaley; 10-03-2020 at 11:18 AM.
chaley is offline   Reply With Quote