Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Need for OPTIMIZE TABLE
Tue, Jun 24 2008 3:23 AMPermanent Link

Oliver Bock
Whenever I install a new version of my software I re-create all my
tables and use INSERT INTO to copy data from the old table into the new
table.  Given that each table is entirely populated by a single query,
is there any need/benefit to run OPTIMIZE TABLE afterwards?  (DBISAM v4
latest)


  Oliver
Tue, Jun 24 2008 5:17 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Oliver


Two things to consider. Firstly I would expect the table should be all in in one block rather than fragmented but secondly it may not natively be in the order you want so an OPTIMIZE will help to speed things up a little bit.

Roy Lambert [Team Elevate]
Tue, Jun 24 2008 8:29 PMPermanent Link

Oliver Bock
Roy Lambert wrote:
> Two things to consider. Firstly I would expect the table should be all in in one block rather than fragmented but secondly it may not natively be in the order you want so an OPTIMIZE will help to speed things up a little bit.

I'll add an Optimize after each upgrade.  Thanks!


  Oliver
Image