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).

Here's another tip to improve Dreamweaver load time. In Preferences select the File Types / Editors screen and add .cfm and .cfc to the Open in Code View list. You'll lose support for design view and the Insert bar, but the load speed will be much faster.