Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread repairTable
Wed, Nov 25 2009 3:10 AMPermanent Link

andrej
Why is the "Table.RepairTable(True)" much slower then RepairTable within dbsys?

In "RepairProgress" are these lines:
ProgressBar.Position := PercentDone
Application.ProcessMessages
Wed, Nov 25 2009 4:05 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

andrej

>Why is the "Table.RepairTable(True)" much slower then RepairTable within dbsys?

Do you have force index rebuild checked in DBSys. If not then Table.RepairTable(True) is rebuilding indices and DBSys isn't

Roy Lambert [Team Elevate]
Wed, Nov 25 2009 7:08 AMPermanent Link

andrej
Tnx, I will check this.
If I am altering structure... do I have to rebuild indexes after?

Roy Lambert wrote:

andrej

>Why is the "Table.RepairTable(True)" much slower then RepairTable within dbsys?

Do you have force index rebuild checked in DBSys. If not then Table.RepairTable(True) is
rebuilding indices and DBSys isn't

Roy Lambert [Team Elevate]
Wed, Nov 25 2009 7:14 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Andrej,

<< If I am altering structure... do I have to rebuild indexes after? >>

No, not at all.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image