Case Study: FANCOMI achieves 10X faster real-time ad analytics and lower costs with Oracle MySQL HeatWave

FANCOMI accelerates ad analytics by 10X with MySQL HeatWave

FANCOMI, a leading Japanese performance-marketing ad network that tracks 20,000 ads across 2.6 million agencies and media sites, faced slowing analytics as advertiser and channel data volumes exploded. Their existing setup on AWS (Aurora MySQL and Oracle on RDS) could not deliver real-time performance—complex queries timed out or took over a minute, forcing costly data movement to a separate warehouse and risking higher instance charges.

FANCOMI migrated to Oracle MySQL HeatWave and Autonomous Transaction Processing on OCI, enabling OLTP and OLAP in one system and eliminating data movement. The change delivered 10x faster complex-query performance for real-time insights, reduced costs (including via Bring Your Own License), required no application changes, and simplified operations through automation, autoscaling, and faster deployments—accelerating time to insight with lower operational overhead.

FANCOMI

Kanami Suzuki

Developer