Skip to main content

Key Concepts

OLAP vs OLTP​

PRISM is built on top of ClickHouse, an ultra-fast columnar data store. While it has a SQL style interface, it is vastly different from a traditional RDBMS like PostgreSQL or MySQL.

Some common tricks to keep in mind:

  • Selecting fewer columns results in faster results
  • Use LIMIT to restrict the number of rows returned, which can significantly speed up your queries.
  • Filter data as early as possible in your query to reduce the amount of data processed.
  • Take advantage of ClickHouse's built-in functions for efficient data manipulation and aggregation.
  • Avoid using SELECT * in queries as this increases the amount of data you must scan significantly; instead, specify only the columns you need.