GetOjectSet is slow

Nov 3, 2011 at 4:31 PM

When I do a context.GetObjectSet<T>(), it takes a very long time.  I did a test on 16,000 records.  It took about 10 seconds to return.

Coordinator
Nov 4, 2011 at 1:50 PM

Hi,

did you try to do some performance measurement to identify where the speed is being lost?

Thanks.

Nov 4, 2011 at 7:06 PM

If I just did a SQL select using the PSQL ADO.NET (Pervasive) and loaded it to a DataTable and it was very quick.

When I use the ObjectContext.GetObjectSet, it is very slow.

Coordinator
Feb 4, 2012 at 5:01 AM

Hi -- did you try to compare the SQL that's being generated by Opf3 with the one you are using? Maybe there's an optimization that should be considered.