Performanceproblem with TVirtualTable.AddField

jonnie · Post by **jonnie** » Tue 23 May 2006 12:26

i'm using ODAC 5.70.1.32 (registered) with D2006.
when i create a lot of Fields using MyVT.FieldDefs.AddFieldDef or MyVT.FieldDefs.Add(...) or MyVT.AddFiled(...) it needs for each next Field much more time as for a previous. An addition of 200 fields needs at my 3GHz P4 1Gb RAM about 30 seconds. Do i have a way to do this a bit faster?

MyVT := TVirtualTable.Create(nil);
for I := 1 to 200 do
MyVT.FieldDefs.AddFieldDef;
...
// MyVT.Open;

it runs with ODAC 3.60 and Delphi6 in just 3 seconds

thank you

Challenger · Post by **Challenger** » Thu 25 May 2006 09:01

We have fixed this problem. In next build of ODAC adding fields will be much faster
when virtual table contains no records.