search

LionWeb-io / lionweb-repository

Reference implementation of LionWeb repository
Apache License 2.0
2 stars 1 forks source link

Performance improvements #56

Open joswarmer opened 4 months ago

joswarmer commented 4 months ago

There are many ways to optimize the current implementation. Which ones are useful often depends on the way applications use the data. In this issue we gather all ideas on how to improve performance.

  1. Using PreparedStatements and ParametrizedQueries might have some performance benefits.
  2. Having the right indices..
  3. Bulk load scenarios: see https://www.postgresql.org/docs/current/populate.html.
  4. Adding the option to not use history tables might be good for performance in case you do not need history. Thus would mean not using history tables at all.
  5. Splitting the current history table that contains all rows including historical ones into two separate tables. One table for the current data, and another table for all historical data. These tables can be seen as one table using Postgres table inheritance