Projection Performace Issue

Posts   
 
    
saravana
User
Posts: 63
Joined: 11-Nov-2010
# Posted on: 10-Jul-2012 17:58:38   

Hi,

I am using dynamic list and data reader to fetch the data from multiple tables (using self servicing). I am using this in all my BL methods to get the custom business object filled from the data reader (loops throuh this and assign field values) manually.

When I read about the usage of projection to datareader to custom class, I tried in one of my simple methods with 5 fields. But the performance is worst than manullay adding to the collection objects.

The below line takes very long time to execute:

dao.GetAsProjection(valueProjectors, projector, Nothing, fields, filter, Nothing, 0, sort, True)

I have just one filter in the filter collection. Is there optimization available in the latest version?

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 10-Jul-2012 20:21:24   

Which version (build no.) of the runtime libraries are you using? (OrmSupportClasses...dll, file version)

Did you profile your application to know whether the delay is done fetching the data, or projecting them?