Postby dynapro » Thu 02 Apr 2009 15:36

Hi @all

The following method needs about five minutes for 200 000 objects. If if just create an add the object and do not update the entities into the Oracle DB (entities.SaveChanges) it takes 4sec.

The Class Entities is created by the wizzard and contains the class PERSON.

public void TestEntities(string connectionString)
var entities = new Entities(connectionString);

long nextID = (from it in Loaded_entities.PERSON select it.ID).Max();

for (int j = 0; j <= 100000; j++, ++nextID)
var p = new PERSON
ID = (nextID),
NAME = "The Name"
entities.AddObject(typeof(PERSON).Name, p);
entities.SaveChanges(); //this needs soooooo long ;-((

What can i do to get a better performance?

thx and best wishes
Posts: 1
Joined: Thu 02 Apr 2009 14:52

Postby AndreyR » Fri 03 Apr 2009 07:01

The problem is associated with the peculiarities of the Entity Framework architecture.
You can find some information concerning the performance improvement here:
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Return to dotConnect for Oracle