This is a migrated thread and some comments may be shown as answers.
Large Object Graphs
1 Answer 14 Views
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Brian Mains
Top achievements
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.

1 Answer, 1 is accepted

Sort by
0
Jan Blessenohl
Telerik team
answered on 02 May 2012, 09:35 AM
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
Follow @OpenAccessORM Twitter channel to get first the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
Tags
General Discussions
Asked by
Brian Mains
Top achievements
Rank 1
Answers by
Jan Blessenohl
Telerik team
Share this question
or