Re:Building the world’s fastest website analytics (2021)
by JackWritesCode on Sunday October 16, 2022 @12:03AM
(#33220938)
I completely agree! For the people following back home, who don’t want to move away from MySQL, can you let us know how to achieve a <10ms GROUP BY aggregation with a high cardinality column (11 million distinct values for “pathname”).
The query was:
SELECT SUM(pageviews) as total, pathname FROM pageviews GROUP BY pathname ORDER BY total DESC LIMIT 10.
If we don’t hear an answer from you, I’ll be really upset. Otherwise, we may have to add your ideas to the article!
Attempting to make your own db while being ignorant of competing products would be an absolute disaster