You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »


Here is a list of tips for optimizing queries written to be run against the LDP reporting database environment from the FOLIO community:

Basic tips for faster queries in LDP databases

  • Indexes
  • Vacuum analyze
  • Temporary tables
  • Breaking apart large queries
  • Use NOT EXISTS instead of NOT IN
  • Simple column names
  • System configuration
  • No labels