SEO

#1 (**permalink**) 02-27-2008, 09:18 PM

Peter Lauri wrote:
> DELETE FROM table

Truncate will be a lot better.

DELETE FROM table will do it row by row which also means it will have to
update any indexes applicable to the table as it goes...

Lots of data & lots of indexes = very slow.

#2 (**permalink**) 02-27-2008, 09:18 PM

But how will that interact with the auto increment counter? Will
truncate reset the counter.

Chris wrote:
>
> Peter Lauri wrote:
> > DELETE FROM table
>
> Truncate will be a lot better.
>
> DELETE FROM table will do it row by row which also means it will have to
> update any indexes applicable to the table as it goes...
>
> Lots of data & lots of indexes = very slow.

--
Chris Wagner
CBTS
GE Aircraft Engines
Chris.Wagner@ae.ge.com

#3 (**permalink**) 02-27-2008, 09:18 PM

Wagner, Chris (GEAE, CBTS) wrote:
> But how will that interact with the auto increment counter? Will
> truncate reset the counter.

According to the docs it will:

http://dev.mysql.com/doc/refman/5.1/en/truncate.html

The table handler does not remember the last used AUTO_INCREMENT value,
but starts counting from the beginning. This is true even for MyISAM and
InnoDB, which normally do not reuse sequence values.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: How to delete all rows....