↳
In-reply-to
»
Problem 2: Your SSD-backed database has a usage-pattern that rewards you with a 80% page-cache hit-rate (i.e. 80% of disk reads are served directly out of memory instead of going to the SSD). The median is 50 distinct disk pages for a query to gather its query results (e.g. InnoDB pages in MySQL). What is the expected average query time from your database?
⤋ Read More
@bender@twtxt.net I reviewed my solution and it’s pretty much spot on! 🤣 the order of magnitude performance is anywhere between 1-10ms