Inserting a record takes forever

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

Inserting a record takes forever

Post by AzE » Sun 18 Sep 2005 17:33

Hello,

I am converting one of my software packages from interbase to MySQL because the customer are in the process to move to MySQL

To cut things simple I am using 2 tables with master detail configuration, the master have aporox 3000 records or so and the detail 7000 records. In the detail table there are 3 fields one key one to relate to the master and one blob wich contains a jpeg approx 70k.

I am using Cbuilder6 and latest version of DAC. When I am browsing or edit records all works fine but adding a new empty record in the master table can take up to 30 minutes.(Can't call that user fiendly :D ).

What to do......
Top
Guest

More info on the above

Post by Guest » Sun 18 Sep 2005 19:51

Yes, i am using query:s and i have tried both metods on master/detial.

I have now tested several configuration are are stable on 18 seconds, wich is 18 seconds to much.

any sugestions...
Top
GEswin
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain
Contact:
Contact GEswin

Post by GEswin » Mon 19 Sep 2005 09:34

Have you a primary key (best autoinc) field in the table ?? Also included that field in the select ?? This speeds up a lot.
Top
Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 19 Sep 2005 10:52

Do you use FetchAll = False mode?
Top
Post Reply

Return to “MySQL Data Access Components”