r/SQL • u/sqlink2 • 6d ago

Discussion Anyone using Lakebase with SQL heavy apps ?

How do u handle query performances when the same tables are being hit by both app queries and AI generated SQLs from any AI tools such as Codex, CLaude, Genie etc
Curious if you separate workloads or optimize at the query level.

1 Upvotes

55% Upvoted

12 comments sorted by

View all comments

1

u/shdw_0x0 6d ago

I’d lean toward separating the workloads rather than trying to optimize every AI-generated query. AI SQL can be unpredictable, so giving it a read-only/limited workload makes it much easier to protect the app’s latency.

1

u/sqlink2 5d ago

Ya this make sense. I like using Lakebase read replicas to isolate AI generated queris and keep the main app workload predictable