Cascading deletes

Classic Servoy
1

When I delete a form that has related tables that will be effected by a cascading delete it takes a really long time (several minutes).

Servoy Client
Version R2 2.1rc2-build 306
Java version 1.4.2_05-b04 (Windows 2003)

2

I meant delete a record from a form.

3

i need an example for this because we only fire related deletes to the database

If relation has one record:

delete from relation_table where relation_table_id = ?

if it has more then one record:

delete from relation_table where relation_where_part = ?

So these deletes should be fast.

When it is slow? If you test it in developer or only when you are using the clients