Quote:
Originally Posted by garcle
What about sorting performance? presumably there would be some penalty for trying to sort on a field in a foreign table (custom_column_x)?
|
Sorting and searching are done on the flattened in-memory cache, so there would be no difference in performance.
There would be a difference in loading the cache. Using a column in the books table would cost nothing. Using my 20,000 book test library, after adding a new custom text column, loading the cache costs an extra 0.1 second (+/- some; it is very hard to get accurate measurements of such small deltas). I don't think that an extra 5 microseconds per book is a deal-killer.
