On Sat, Jan 14, 2012 at 3:57 AM, Mason James
<mtj@kohaaloha.com> wrote:
> Truncating should work fine, but I saw somewhere (I think in the e-mail archives not positive), that it could take longer. I'm not sure that is true or not since I didn't try it. The advantage to truncate though would be I wouldn't have had to look up how to recreate the table.
>> just curious, why not just truncate the table?
aaah, that Q was for Jared... :)
but answering my own question, i guess its because for the default inno-db config for mysql, a truncate wont delete the existing space for that table - where as a drop/create will