Option to choose between using truncate() and delete()

[seb-jones]

Using delete() can be faster, but it does not reset auto-increments.