I just deleted 2500 records in Servoy Developer.
And it took about 30 minutes!!!
(yes it does have about 6 related tables, that also has to be deleted)
But does it really have to take this long?
I just deleted 2500 records in Servoy Developer.
And it took about 30 minutes!!!
(yes it does have about 6 related tables, that also has to be deleted)
But does it really have to take this long?
I suppose that if cascade deletes inside Servoy are involved, your records have to be deleted one by one. It is probably faster to have a constraint in the database that deletes related data.
I had this problem.
Much quicker to delete master records in servoy and leave children records to be deleted by some other process outside of Servoy (e.g. stored procedure)