Subject | IBX Admin Comps and FB 1.5 SS RC8 on Linux or FB 1.5 Final and Win XP. |
---|---|
Author | R. S. Patil |
Post date | 2004-02-28T18:29:27Z |
Dear friends,
I am Using IBX admin Comps in my Delphi 5 Application
for doing some routine database Maintenance Work.
PART - I
=======
1. IBConfigService
SetSweepInterval(0);
2. TIBValidationService
Options := [IgnoreChecksum,ValidateDB,ValidateFull];
3. TIBValidationService
Options := [IgnoreChecksum,MendDB];
if Above Are Successful then Following are executed
PART - II
=======
1. TIBValidationService
Options := [LimboTransactions];
2. TIBValidationService
Options := [IgnoreChecksum,SweepDB];
It has been noticed that after shifting to FB 1.5 RC8
Some times Part - I & Part -II takes about 10 to 15 min
and Some Times 1 Hr, 1.5 Hr or Occasionally 3 hrs Too.
The common observation is excessive timings are recorded
when database is Backed up and Restored on Existing gdb
Using IBX comps.
after successive execution of this procedure for 3 to 4 days
Timings start getting reduced back to 10/15 Mins.
Can Somebody help me in this Matter.
Best Regards
R. S. Patil
I am Using IBX admin Comps in my Delphi 5 Application
for doing some routine database Maintenance Work.
PART - I
=======
1. IBConfigService
SetSweepInterval(0);
2. TIBValidationService
Options := [IgnoreChecksum,ValidateDB,ValidateFull];
3. TIBValidationService
Options := [IgnoreChecksum,MendDB];
if Above Are Successful then Following are executed
PART - II
=======
1. TIBValidationService
Options := [LimboTransactions];
2. TIBValidationService
Options := [IgnoreChecksum,SweepDB];
It has been noticed that after shifting to FB 1.5 RC8
Some times Part - I & Part -II takes about 10 to 15 min
and Some Times 1 Hr, 1.5 Hr or Occasionally 3 hrs Too.
The common observation is excessive timings are recorded
when database is Backed up and Restored on Existing gdb
Using IBX comps.
after successive execution of this procedure for 3 to 4 days
Timings start getting reduced back to 10/15 Mins.
Can Somebody help me in this Matter.
Best Regards
R. S. Patil