BAUMEISTER Alexandre writes:
> Bonjour,
>
> With 3.22 I used to do some queries like "DELETE FROM TABLE". And
> this was very rapid as Mysql only deletes and re-create the files.
>
> I knew that DELETE was very long with InnoDB because it has to
> clear all the table space used by the table from which you DELETE.
>
> But I'm surprised to see that it's very long with MyISAM too !
>
> When I do a "DELETE FROM TABLE" (without any where) on a big
> table, it takes many minutes. And if I look at the table files,
> while the table is empty, the files are still very big.
>
> The only way to reduce space used by the table is OPTIMIZE.
>
> Is this normal ? Is this a difference between ISAM an MyISAM ? I saw
> no notice about that in the documentation ...
>
> Regards,
> Alex.
Have you tried TRUNCATE command ??
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php