This project is read-only.

GetOjectSet is slow

Nov 3, 2011 at 5: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.

Nov 4, 2011 at 2:50 PM

Hi,

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

Thanks.

Nov 4, 2011 at 8: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.

Feb 4, 2012 at 6: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.