News for hackers. Stuff that matters.
Re:Building the world’s fastest website analytics (2021) by nnopepe on Saturday October 15, 2022 @12:05PM (#33215960)
These people don't have the inhouse skills to maintain a simple SQL server, let alone optimize their schema (MySQL being too slow to sum/group 11m records in a timely manner? Please.)

Attempting to make your own db while being ignorant of competing products would be an absolute disaster

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!