Quote:
Originally Posted by chaley
Unless the value is precomputed for each book (book, not format), a custom column would be a performance catastrophe. Reason: touching any custom column for a book record causes the computation of them all. Sorting on something would compute the word count for all books in the library. Doing that for 10,000 books could take many minutes.
|
Yeeps, that's not good. Good brainstorming, though, thanks Idolse and chaley!
Is there any way to add a metadata field to hold the page or word count, then have it populate on either an add or a database check? It would extend the time for a db check, but that takes some time for 10,000 books anyways...and I wouldn't think it would add too much overhead to the add function, since people aren't likely to try adding that many books at once.
I'm not sure if adding a metadata field to a book is available to the average user, though, or if it would require a plugin. That's outside my expertise, i'm afraid...
