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