The default and most commonly used table engine in ClickHouse, MergeTree, is optimized for high-throughput batch inserts. It writes each insert as a separate partition, then runs background merges to keep data manageable. This makes writes very fast, but not when they arrive in lots of tiny batches, which was exactly our case with millions of individual devices uploading one log event every 2 minutes.
"The games industry, and particularly the mobile space, is constantly evolving to match the everchanging needs and desires of players and their demands," said Appcharge CEO Maor Sason.