I have some hundres of tables in a DbMetal generated DataContext class with
a lot of foreign key relations.
Using DbLinq from SVN causes test below to take 5 seconds to run and CPU
usage is 100%.
In old DbLinq this test will complete immediately. This makes new DbLinq
useless for me.
I havent found cause for this. Maybe ThreadSafeDictionary locks, maybe large
number of tables or relations with null values, maybe
some objectfactory, maybe something other.
How to fix or debug this ?
Andrus.
Stopwatch stopWatch = new Stopwatch();
stopWatch.Start();
for (int i = 0; i < 5; i++)
using (var db = new
MyDbMetalGeneratedDataContext(myPostgreSqlConnection))
{
db.ExecuteCommand("select 1");
}
stopWatch.Stop();
MessageBox.Show(stopWatch.Elapsed.ToString());
Note: If
db.ExecuteCommand("select 1")
line is removed, problem persists.
I tried
base.DeferredLoadingEnabled = false and true values
base.ObjectTrackingEnabled = false;
but those do not affect to speed.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
