On Tue, Oct 4, 2011 at 1:25 AM, Muthu Annamalai
<muthuannama...@sbcglobal.net> wrote:
> When I use ObjectSet.ToList, the provider creates an select statement for
> each and every record in the list and it takes forever to load an list of
> 10000 records.
>
>
>
> But instead if I use like
>
> “From item in Objectset select item.id, item….” It only creates one single
> statement and in blink of an eye it loads all the records. I am also
> attaching the SQL statements that is sent by the provider to the database…
Because these two statements are not equal.
--
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
