# Performance Metrics

URL: https://rivo.tools/docs/cfx-db-performance-metrics

Real-world benchmarks comparing CFX-DB to OxMySQL - both running locally for fair comparison

1.1x Faster atomic transactions

CRITICAL FOR FRAMEWORKS

50% Fewer database queries

REAL-TIME UPDATES

0ms Polling overhead eliminated

PUSH-BASED UPDATES

✅Production framework tested

ESX, QBCORE, CUSTOM

| Operation | OxMySQL | CFX DB | Cached |
| --- | --- | --- | --- |
| Transaction (4 operations)<br>Atomic money transfer with audit log. CFX-DB wins with server-side atomic mutations! Critical for framework servers. | 180 ms | 169 ms | N/A |
| Real-time Updates (Leaderboard)<br>CFX-DB eliminates polling entirely with real-time subscriptions. Massive savings for framework servers with live dashboards. | Polling every 5s | Push-based (0 polling) | Instant push |
| Complex Query (TOP 10 players)<br>WHERE + ORDER BY + LIMIT with server-side aggregation. CFX-DB uses optimized Convex function. HTTP overhead vs local protocol. | 77 ms | 156 ms | 163 ms |
| Simple SELECT (1 record)<br>Single record lookup by index. OxMySQL faster due to local protocol. Rarely the bottleneck in production frameworks. | 74 ms | 218 ms | 201 ms |
| Bulk Insert (100 records)<br>Server-side batch mutations. CFX-DB optimized for bulk operations. Essential for framework data migrations. | N/A (individual inserts) | Batch mutation | N/A |
