Why Insert is slowly?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
kitten
Posts: 1
Joined: Thu 03 Nov 2005 17:20

Why Insert is slowly?

Post by kitten » Thu 03 Nov 2005 17:25

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...

:)

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Fri 04 Nov 2005 12:26

Try to connect to localhost.

Post Reply