Devart Forums

I have a table,

When i insert a new record it take 40 second when i assign the initial value to some field,

But if i don't assign the initial value for some field, it is quickly...

the code like below:



MyTable1.Insert; <===Insert here

MyTable1['ratio_A']:=0.95;

MyTable1['ratio_B']:=0.95;

MyTable1['LimitsA']:=30000;

MyTable1['LimitsB']:=30000;

MyTable1['Differ']:=200000;

MyTable1['Differ_Admin']:=100000;

MyTable1['group_up']:=20000;

MyTable1['Pay_up']:=10000;

MyTable1['Pay_lower']:=1000;

MyTable1['Percent_1']:=0.010;

MyTable1['Percent_2']:=0.020;

MyTable1['Hight_Ratio']:=1.00;

MyTable1['Low_Ratio']:=0.60;

Is there any method to fix it ,

Sorry for my pool english...

Try to connect to localhost.