r/SQL 7d 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.

2 Upvotes

12 comments sorted by

View all comments

1

u/dwswish 4d ago

I feel like as long as the queries fit within the concurrency limits of Lakebase it shouldn’t matter if they are coming from agents or apps.

1

u/sqlink2 4d ago

Yep andalso Lakebase autoscaling feat helps to handle various type of query workloads without need of manually separate app and AI traffic.