Platform: LLBGen Pro v2.6, SQL 2005, Compatibility SQL 2005, C# 3.5

Loading data in pages. First time load takes 345 ms, next 57ms and so on... SQL Server profiler shows query taking only 26 ms for the first data pull.

How can I improve the first load time?

Hi there,

We need more information, so I have a couple of questions:

What exactly are you loading? Are there CLOB/BLOB fields in the entity? Do you use prefetch paths or just a single collection? How many fields are there in the entity? How many entities are you fetching? Exact runtime library version (http://llblgen.com/tinyforum/Messages.aspx?ThreadID=7722)?