Delete with no criteria TRUNCATEs table

If no criteria are passed to the delete function on the driver, a TRUNCATE TABLE is performed.

TRUNCATE TABLE is fast because it does not bother logging, which can break some DR or other replication scenarios. We should just use DELETE FROM with no criteria in this case, which removes all data from the table with transaction logging.

Komentarze:

Brak komentarzy