Faster SQL Deletes
8 March 2007 02:00 (EST)
Want to delete all data in a table? You can use DELETE FROM TABLE, but that is slow because changes are logged. A faster solution is to issue a TRUNCATE TABLE command which is faster because no logging occurs (and if really intent to delete all the data in a table, logging is probably not that important).
← How To Access Badly Named Form Fields: Previous
Next: List MX Datasources →
Discussion (no comments)