Performance improvement, questions...

Posts   
 
    
pawlenty
User
Posts: 4
Joined: 02-Jul-2008
# Posted on: 10-Jul-2008 12:18:28   

Hello

During using llblgen I allways fetch entitycollections. But as I know, during fetching llblgen take data from all fields which are in table. But sometimes I need to fetch only 2 or 3 fields. Can I use in this case dinamicList and can it really improve the performance?

Thanks, Pavel

Walaa avatar
Walaa
Support Team
Posts: 14994
Joined: 21-Aug-2005
# Posted on: 10-Jul-2008 12:28:15   

You have 2 options:

1- Use a dynamicList, this should only be used for read-only purposes. 2- You may fetch the entityCollection, while excluding/including the specified fields.Check this out

pawlenty
User
Posts: 4
Joined: 02-Jul-2008
# Posted on: 10-Jul-2008 15:38:53   

I'm using llblgen v 1.0.2005.1, the second option is not for me simple_smile

Walaa avatar
Walaa
Support Team
Posts: 14994
Joined: 21-Aug-2005
# Posted on: 10-Jul-2008 15:46:19   

Oh, I see, don't keep it to yourself next time smile

Then, a DynamicList is your option.

OR if there are many cases in which you want a slim version of this specific entity, and you want to fetch it in a read-write way without the extra fields (eg. BLOB fields)

You may use the Designer to map another entity into the same table, but this time you remove the unwanted fields.

This results in having 2 entities to deal with the same table (eg. CustomerEntity & CustomerSlimEntity ) simple_smile