Optimizing MariaDB JSON Queries with Virtual Generated Columns
Stop relying on full table scans for JSON data. Learn how to use MariaDB Virtual Generated Columns to index specific JSON keys for relational-speed performance.
Loading…
ReadMeFeed / Community knowledge
#indexing
Real questions. Useful conversations. Find the people who know your stack.
jsonDiagnosing and Fixing GoLand Indexing Stalls and High CPU Usage
A step‑by‑step diagnostic guide for GoLand indexing stalls: identify the offending thread, exclude vendor/build directories, tune JVM heap, handle symlinked caches, and know when to escalate to JetBrains Support.
golandFaunaDB Query Optimization: Index vs Filter Decision Guide
Use FaunaDB Indexes to restrict candidate sets before applying Filters, avoiding full collection scans and reducing read costs.
faunadbUsing MySQL Covering Indexes to Cut Disk I/O on Read‑Heavy Tables
Learn how MySQL covering indexes let queries read data directly from the index tree, cutting disk I/O, and see the trade‑offs in size and write performance.
Optimizing Aerospike Secondary Indexes for High-Performance Querying
Learn how to implement and manage Aerospike secondary indexes to enable non-primary key lookups without the performance penalty of full cluster scans.
aerospikeDiagnosing & Fixing High N1QL Latency Caused by Missing or Inefficient Indexes in Couchbase
When N1QL queries stall, the first culprit is often an absent or poorly defined index. This guide walks through spotting full scans, interpreting query plans, and applying targeted index changes to bring latency back under control.
couchbaseArchitecting Project Search: How the IntelliJ Platform Indexing System Works
Explore the architecture of the IntelliJ Platform's indexing system, focusing on how 'stubs' enable fast navigation in large codebases without constant full-file parsing.
jetbrainsMariaDB JSON Storage: Choosing Between LONGTEXT, Validation, and Generated Columns
MariaDB stores JSON as LONGTEXT, not a binary type. This guide compares plain text, the JSON alias with validation, and generated-column indexing to help you pick a storage strategy.
Indexing a Field in CouchDB with a MapReduce View
Learn how to create a CouchDB design document that indexes a document field using MapReduce, query it efficiently, and avoid common pitfalls.
couchdb