This question is locked. New answers and comments are not allowed.
Brian Mains
Top achievements
Rank 1
Rank 1
Brian Mains
asked on 27 Apr 2012, 04:09 PM
Hello,
I am working on a process that will work with 2500 objects or more. I was curious how Telerik OpenAccess handles this large of a result set, especially when attached to the OpenAccessContext.
Thanks.
I am working on a process that will work with 2500 objects or more. I was curious how Telerik OpenAccess handles this large of a result set, especially when attached to the OpenAccessContext.
Thanks.
1 Answer, 1 is accepted
0
Hello Brian,
OpenAccess reads the query result in chunks from the wire and creates internal representations of the data. As long as you do not iterate the query result completely (or call ToList()) we keep the server side cursor open. Only if you touch the result object, we create it and handle it to you. If the object has references or collections of references, we also only create (or load) the references objects if you touch them. After each Clear or SaveChanges call, we break those graphs so that the GC is able to free memory if necessary. This happens only if the memory is really low because we keep the data in a weak reference list which is rarely cleared by the GC. If you have bigger memory troubles, you should dispose context instances if the were data intensive asap.
Regards,
Jan Blessenohl
the Telerik team
OpenAccess reads the query result in chunks from the wire and creates internal representations of the data. As long as you do not iterate the query result completely (or call ToList()) we keep the server side cursor open. Only if you touch the result object, we create it and handle it to you. If the object has references or collections of references, we also only create (or load) the references objects if you touch them. After each Clear or SaveChanges call, we break those graphs so that the GC is able to free memory if necessary. This happens only if the memory is really low because we keep the data in a weak reference list which is rarely cleared by the GC. If you have bigger memory troubles, you should dispose context instances if the were data intensive asap.
Regards,
Jan Blessenohl
the Telerik team
Follow @OpenAccessORM Twitter channel to get first the latest updates on new releases, tips and tricks and sneak peeks at our product labs!