Thanks, Tobias, bought a copy, maybe I learn something that I can apply to improve the performance of my analytics app schema or indexes [0].
Based on your experience, if the proper indexes are in place, would a ~10m rows MySQL database have similar read performance to a larger, ~100m rows database, if we would aggregate over the most recent ~1m rows in both cases?
I am struggling a bit to maintain sub-second queries for databases over ~20m rows, even when the proper indexes seem to be in place.
Based on your experience, if the proper indexes are in place, would a ~10m rows MySQL database have similar read performance to a larger, ~100m rows database, if we would aggregate over the most recent ~1m rows in both cases?
I am struggling a bit to maintain sub-second queries for databases over ~20m rows, even when the proper indexes seem to be in place.
[0]: https://docs.uxwizz.com/guides/database-querying