Problem:
I have a MYSQL DB ( → contacts) with about 35.000 records.
If a select “Delete all” Servoy takes over an hour (via DSL) to delete all records. Seems like each record is deleted row by row.
Is there a way to speed this up ?
Rainer
I have posted a question about this too (don’t know where anymore). The answer was: do it outside Servoy for now since every row is checked at the moment. Servoy however is looking into this…
An performance enhancement is on the planning, incase tracking is not used and delete related rows is not used in one of the relations.