Hi, I am using LLBLGenpro2.0 version. My web application platform is C#.net2.0,SQL Server 2005,ReportingService2005,Telerik cotrols,dundas etc., Our web application is Financial & Statistical domain application and the database contains more than 7 lakhs record.It is having all primary foreignkey relationships and indexes also.

EntityCollection VS Storedprocedure; 1.When i use entitycollection object for batchprocess my application is too slow compare to storedprocedure via LLBL. 2.When i use select statement through LLBL it is fast to retireve dataset object.But if i use entitycollection with filters it is slow.

Is there any specific document to identify which scenario we have to use which objects? We are using LLBLGen objects only in our applications. Need more suggestions to improve performance of our application..

Anyone can help us to proceed further.

Thanks & Regards, Balaji

Please specify what kind of queries you're using. Entity collection fetches aren't really slower than proc fetches in datatables. It might be your queries are a little inefficient because you're using a lot of joins which might create a lot of duplicates and you should use fieldcompareset predicates instead (or vice versa)

Also, what's '7 lakhs record' ?

You could see which queries are generated by using tracing, or the sqlserver profiler.

So an example of what you use NOW which is very slow, would be helpful as we don't have your code in front of us.