Zermelo Demo: Northwind Order Index Report

The performance of this report should be pretty zippy for ordering and for searching various fields... because the cache table has been indexed.
Compare this to Northwind Order Slow Report which is the same report but without indexes
Test this report for

  • To make sure that the caching is functioning correctly. It has a very short cache time to facilitate this
  • To make sure that cache indexing is working correctly. Confirm that the back-end cache in _zermelo_cache (presumably) is properly indexed
  • The index SQL stage can run any SQL, including SQL that changes the field types of the cache, make sure those work
  • Do some searches and filters that are designed to test the backend system and make sure that indexing is effective