Overview
MTV Oy, Finland’s leading commercial TV broadcasting company, partnered with Cirit to optimize their election results web application during the 2023 Finnish parliamentary elections.
The Challenge
During previous elections (2022, 2021), MTV’s election results application took over four minutes to process voting data, causing delays. The 2023 election featured 2,424 candidates with hundreds of thousands of concurrent visitors.
Solution Architecture
The solution was built entirely on AWS managed services:
- CloudFront and API Gateway
- Aurora Postgres Serverless
- DynamoDB
- AWS Lambda functions
- CloudWatch monitoring
- Amazon EventBridge
- Secrets Manager
- S3 storage
Lambda functions retrieved data files from remote servers every five minutes, storing them on S3. This triggered parallel Lambda executions to decompress files and batch-load CSV data into Aurora Postgres Serverless.
Results
- Data processing speed improved by 50% — from over four minutes to approximately two minutes
- Peak traffic: 45,000–95,000 requests with error rates between 0.5–1.75%
- Aurora database at 384 ACUs from vote counting start