Rohit,

This is a result of the line of code included at your request. At least I
think it was you that asked to have the following line of code added:

procedure TIBODataset.InternalOpen;
begin
...
InternalDataset.Open;
{$IFDEF IBO_VCL40_OR_GREATER}
IndexDefs.Update;
{$ENDIF}
end;

This forces the IndexDefs to be updated when a table is opened rather than
deferring it to when needed only.

Is there a way we can make the operation more efficient?
I'd be happy to consider all suggestions.
40 secs sounds like a horribly unacceptable delay.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Rohit Gupta" <rohit@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, August 02, 2001 4:46 AM
Subject: [IBO] Slow at Startup


> Using IBODatabase and IBOTable, I am expreiencing a delay of about 40
secs.
> WIth the monitor I see that whenever the first table is opened (doesnt
> matter which one), something reads all the indexes in the database (one
per
> statement).
>
> Does anyone know whats happening. It did not use to happen, so either its
a
> sideeffect of an update or I have accidentally changed something. I have
> gone thorugh all the properties, and they look fine.