There is a slight chance that I may have changed something else.
Poke around in the IB_Schema.pas unit and the IBA_SchemaCache.IMP file and
it might become apparent what has changed. What might be the case is instead
of poking in index defs a table at a time I decided to slam them all into
the cache for all tables in one whack.

I'll have to review this. Is it possible you can use schema caching? This
would alleviate this performance hit significantly.

I also would like to avoid bringing in the indexdefs until they are actually
needed for something. Placing that line of code in the Open method is not
ideal in my mind. But, since I don't know exactly how people are expecting
to use it I am not sure what else to do with it. More homework to do I
suppose...

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 9:01 PM
Subject: Re: [IBO] Slow at Startup


> Jason,
>
> I dont see how it can be... its not just reading the indexes for that
> table, but for all 90+ tables... thats why it is slow. I will try
> removing it so if its the culprit.
>
> To: <IBObjects@yahoogroups.com>
> From: "Jason Wharton" <jwharton@...>
> Date sent: Thu, 2 Aug 2001 10:26:03 -0700
> Send reply to: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Slow at Startup
>
> > 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.
> >
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
> Regards
>
> Rohit
>
> ======================================================================
> CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand
> PH (649) 489-2280
> FX (649) 489-2290
> email rohit@... or r.gupta@...
> ======================================================================
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>