We (my team) are going to start developing a mission critical project, one of the sub-systems of this project A Windows service The service will be the backbone of the entire system and it must answer according to the important standard of mission.
This service will include several lists to reduce database interaction and achieve performance, I am estimating the average size of the list, which is 250,00 in normal circumstances.
Is it good idea to use LINQ to ask data from these lines, or should I follow my original plan to create an indexed list?
There is a custom implementation of the indexed list Idictionary , which will work with an index and several display-oriented features such as MRU, index reconstruction, etc.
Solving yourself before rolling, you may want to see the indexed index for the object provider.
Otherwise, this may seem like applying your own indexing - but first do perform testing. Against the "mission critical" performance, it is often about reliability - if LINQ does the object well, why not use it?
Even if you do write your own collection, you should consider creating a "LINQ query" in some fashion (which is the exact format of the collection Will depend on ...) It is good to be able to write LINQ queries, even if it is not against vanilla object from LINQ.
Comments
Post a Comment