![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Tue, Jun 24 2008 3:23 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 PM | Permanent 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |