Our calls to the db are taking much longer then they should. Are there any suggestions on programs that could help us tune the sql that comes from llbl

Hi BaileyK83,

Could you please elaborate more on why "calls to the db are taking much longer then they should"?

The key is identify where the lateness is: how you construct your filter, how much data you are fetching, how your DB schema was designed, how your indexes are set-up/used, etc.

LLBLGenPro framework don't look at DB indexes or the best DB schema suggestion. At the end LLBLGenPro just send SQL queries to the DB engine. So there isn't a mixed tool that comes with LLBLGenPro that tunes your DB. You should talk with your DBA and define the best DB schema and indexes to use.

Anyway, please consider the LLBLGenPro Best Practices (read LLBLGenPro Help - Best Practices).

These threads should help you here as well: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=2218 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=8187