Perhaps what is happening is it is needlessly refreshing index definitions
over and over again instead of loading them once and then storing them.
Please look at the source with this perspective and let me know what you
think. If this is the case, the schema cache may not actually be a magic
bullet.

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

----- Original Message -----
From: "Sean Leyne" <sleyne@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Thursday, October 18, 2001 2:48 PM
Subject: Re: [IBO] Migrating BDE/MIDAS applicaiton to IBObjects and MIDAS


>
> ""Jason Wharton"" <jwharton@...> wrote in message
> news:035801c1581b$8ea36a00$d6756a41@CX170673E...
> > Is it a one-time hit or does it cause a repeating performance burden?
>
> Happens everytime.
>
> > How many indexes are in your database?
>
> 423
>
> > This is something that the SchemaCache may help out in.
>
> I'll look into that.
>
>
> Sean