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@...
======================================================================