moai-domain-database

Run EXPLAIN ANALYZE BUFFERS on the slow query to identify full table scans, then create partial or composite indexes matching the filter columns. For frequent analytics, materialized views with concurrent refresh can reduce query time from seconds to milliseconds.

Start with a $match stage backed by an index, then use $group for metrics, $lookup for joins, and $project to shape output. Create compound indexes on filter and sort fields, and enable allowDiskUse for large result sets.

Cache-aside checks Redis first and populates it only on a miss, while write-through updates the database and cache together on every write. Both patterns require explicit cache invalidation on updates to avoid serving stale data.

Yes, python-oracledb provides create_pool_async for async connection pools with configurable min, max, and increment settings. It also supports statement caching via stmtcachesize to improve repeated query performance.

Stale data occurs when cache entries are not invalidated after database writes. Delete the specific cache key and any related key patterns immediately after updating the source data, and set appropriate TTLs as a safety net.

Use polyglot persistence when different data types have distinct access patterns, such as structured records in PostgreSQL, flexible documents in MongoDB, and real-time counters in Redis. It adds synchronization complexity, so avoid it when one database handles all workloads adequately.