You are right. I thought lazy loading will be useful and scared to remove to it. Thanks!
-----Original Message----- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Tuesday, October 04, 2011 11:17 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Entity Framework On Tue, Oct 4, 2011 at 5:44 PM, Muthu Annamalai <muthuannama...@sbcglobal.net> wrote: > It seems like the provider is issuing select statement for each record and No it's not. It's doing it in one query. BTW provider isn't issuing any query. It's just sending commands requested by EF: > it takes a while (8 min) to retrieve all records You're probably facing lazy loading. > I am also attaching the debug output for your reference. > > Please let me know if you need any further info... -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---------------------------------------------------------------------------- -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider