Entity or TypedList for lookup.

Posts   
 
    
Answer
User
Posts: 363
Joined: 28-Jun-2004
# Posted on: 05-May-2006 23:52:46   

Im need to fetch some lookup info, and this going to be remoted over binary http.

Basically, i have a manufacture entity, and i need 2 of the 12 fields, ID and Name for populating comboboxes. Which would be more efficent. I know for fetching under 10 records, its Entities hands down, but what about 100+, i think that probably 500 would be the max ever listed, but ya never know.

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 06-May-2006 00:48:46   

It could depend on how much data is kept in the other 10 items. If they are large columns then it would push you more towards the typedlist. Since the entitycollection is so easy to use you may try it with that first and see how it works for you, if the performance needs tweaking then give the typedlist or dynamiclist a try.

Answer
User
Posts: 363
Joined: 28-Jun-2004
# Posted on: 06-May-2006 01:11:56   

Sorry, i should have mentioned that, if i use an entitycollection, i will create second entity, manufactureLookUp entity which will contain only the 2 fields i need. simple_smile

Barry
User
Posts: 232
Joined: 17-Aug-2005
# Posted on: 06-May-2006 04:17:49   

I'm using dynamiclist for lookup data. It is flexible and the performance over remoting is good if your data size is not too large, I feel it is unacceptable slow when the datatable contains over around 50000 rows, the serialization process in .net is slow for large objects.