Inserting records MySQL very slow

Classic Servoy
1

I’ve got a problem with inserting records into MySQL.
I use 7 different tables which are related to each other, but when I am creating new records with Servoy it takes about 4 minutes for 88 record and sometimes more than 3 hours for 4800 records.

The strange thing is that when I import it from an Excel sheet into a temporary table with the same ammount of records it is done within +/- 30 seconds, using 2 different tables.
What can be the problem?

And when I’m using the same method in Sybase it is much faster, could this be an MySQL problem?

Cheers,
Rick

2

I don’t think it is a MySQL problem, anyway can you post the code you are using?
Did you check your MySQL error logs?

3

ngervasi:
I don’t think it is a MySQL problem, anyway can you post the code you are using?
Did you check your MySQL error logs?

I found the problem in the relation which I use.
But I dont know how to solve that on this moment.

I will post the code asap.

cheers