Speed issue's after record delete

Hi all,

well i am having a speed issue. I tried to track it down and i found the following.

In my software the user wants to add a record. He presses an "add" button

a form is shown and the add function from the datacontrol on that form is then called. The user can input his options. There is a "save" button on the form to save the actuall data. Everything works ok

If add let's say 10 records after each other (so push the "add" button, form gets loaded. Push the save button on the form and the form is unloaded) everything works fine. No speed issues.

But now for the problem. There also is a "Delete" button on the form. All it does is call the delete methotd of the datacontrol that is on the form. This is al pretty straigthforward database programming.

But i get speed issues with the first record that will be added after i have deleted a record.

So i add 3 records. Then open the 3e and delete it. Then add another record. It takes almost 10 times the normal time to add this new record. After that has been done and i add another record everything is fine again. If i delete a record then the same speed issue occurs again for the next record i want to add.

Any ideas?

Regards,

per-i