Re:The SQLite Index Suggester
by contingencies on Tuesday July 05, 2022 @03:54PM
(#31992895)
Sin #5 - Unrepresentative workloads: The common assumption in academic research systems is that the cluster workload is relatively homogenous. Most research evaluations measure performance by running a single job on an otherwise idle cluster. - Schwarzkopf et al, 'The seven deadly sins of cloud computing research' (2014)
Re:The SQLite Index Suggester
by jessaustin on Tuesday July 05, 2022 @05:27PM
(#31993944)
It seems better for birthdate to be stored in the database and age just to be calculated when needed?
Re:The SQLite Index Suggester
by realPubkey on Tuesday July 05, 2022 @06:30PM
(#31994549)
Yes of course you better store the birthday normally.
This was just a projection of the real data set, used in my testings.
The 'age' thing might be due to the difference between floats and ints?
Integer "age" has many repeats, but random floats are unique. That, or random ints might be from a large pool, again not many repeats.
[1] https://rxdb.info/query-optimizer.html