Inserting a record takes forever
Posted: 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
).
What to do......
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
).What to do......