Subject IBX Admin Comps and FB 1.5 SS RC8 on Linux or FB 1.5 Final and Win XP.
Author R. S. Patil
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