GlimpseBI
FeaturesUse casesPricingFAQDocsBlogGet the free plugin
← Docs

Documentation

Pro

Materialization

A Pro feature that pre-computes a chart’s results into a dedicated summary table on a schedule — turning slow queries on large databases into instant dashboard loads.

Step by step

  1. 1Open a chart in Glimpse BI → Builder (GUI mode).
  2. 2Scroll to the Materialization section.
  3. 3Toggle “Enable materialization” on (Pro required — the toggle is shown but disabled on the free tier).
  4. 4Choose a refresh cadence: Hourly, Twice daily, or Daily.
  5. 5Save the chart. Glimpse BI creates a summary table and schedules the refresh.
  6. 6The chart now reads from the summary table and shows “Last refreshed”.
  7. 7Use Refresh now to rebuild on demand, or Disable to drop the table and return to live mode.
The chart builder's Cache-as-summary-table control — pick a refresh cadence and enable pre-computation.

When to use it

Reach for materialization when a chart aggregates over millions of rows or joins several large tables and its live query is slow. The materialized read path sits under the same cache layer, so the two compose.

Safety

Editing a materialized chart’s definition automatically disables materialization and reverts it to live mode, because the projection may have changed — just re-enable when you’re done. Non-deterministic SQL (NOW(), RAND(), etc.) is rejected, and SQL-mode charts run live in v1.x.

Reference

TierPro only
CadencesHourly · Twice daily · Daily
On editAuto-disables, reverts to live
SQL-modeRuns live (not materialized in v1.x)
NextEmbeds & shortcodes

Bring your WordPress data into focus.

Install the free plugin and build your first chart in minutes. Upgrade to Pro when you outgrow the caps.

Get the free pluginSee pricing