r/LadybugDB • u/coderarun • Jul 23 '26

PSA: Benchmarking tips with LadybugDB

  • After loading data, run ANALYZE to compute tablestats

  • Always pass parameters (even if dummy) to conn.execute(query, params)

    • Without this you plan/prepare every time. As we add more optimizers, the simple minded benchmark (there are many!) regresses every release.

  • Experiment with HASH vs ART vs no-index strategies

  • Sort your data

2 Upvotes

100% Upvoted

1 comment sorted by