Subject Re: [IBO] Schema Cache
Author brian.nuvu
--- In IBObjects@yahoogroups.com, Thierry Holtzmann <tholtzmann@...> wrote:
>
> I am using this feature with IBO 4.8.7 without any problems. I use the
> TDataset compatible components.
> Before connecting I set the property of SchemaCacheDir of my
> TIBODatabase component to an existing directory. After first connection
> IBO creates a subfolder of the path in SchemaCacheDir with the name than
> the database (without extension).
> For remote access I use Zebedee between XP clients and linux server,
> with a connexion string like localhost/3051:/linux_path/database.fdb
> (properties server=localhost/3051, path=/linux/database.fdb)
>
> brian.nuvu a �crit :
> >
> >
> > --- In IBObjects@yahoogroups.com <mailto:IBObjects%40yahoogroups.com>,
> > Ales Kahanek <ales.kahanek@> wrote:
> > >
> > > Thank you for all of you for a help. I have received a small demo
> > app from
> > > Harald Klomann and I started from scratch according to this demo and
> > all is
> > > working fine now. There was some peculiar mistake from my side, I
> > guess, but
> > > cannot say where.
> > > Thanks again
> > > Ales
> > >
> > > > -----Original Message-----
> > > > From: Geoff Worboys [mailto:geoff@]
> > > > Sent: Friday, August 02, 2002 11:40 PM
> > > > To: Ales Kahanek
> > > > Subject: Re: [IBO] Schema Cache
> > > >
> > > >
> > > > > I would like to use TIB_Connection.SchemaCache.TableNames property,
> > > > > but when I want to read it in my code, I always receive an empty
> > > > > StringList.
> > > >
> > > > First things first...
> > > >
> > > > Set up a small test application accessing a predefined database, say
> > > > employee.gdb. DONT use the SchemaCacheDir and try to access the
> > > > TableNames. Does it work?
> > > >
> > > > Presuming the above is OK then in your app get rid of the
> > > > SchemaCacheDir (to begin with at least) and try using the TableNames.
> > > > Does it work?
> > > >
> > > > If not, are you doing anything unusual? For example creating the
> > > > database and running a script - then immediate trying to read
> > > > TableNames without an intervening disconnect/connect ??
> > > >
> > > > If not, try to isolate the problem by creating a simple app based on
> > > > what you are doing in your main application. If you can produce a
> > > > relatively simply example you can send it to Jason or myself for
> > > > further investigation.
> > > >
> > > > --
> > > > Geoff Worboys
> > > > Telesis Computing
> > > >
> > >
> >
> > Hi,
> >
> > I have exactly the same issue - using 4.8.6 IB OBjects - am setting
> > the 'SchemaCacheDir' to 'c:\temp' - and have tried various other
> > folders on different drives - the sub-folder (with the FBD filename)
> > is never created.
> >
> > Tried setting the 'SchemaCacheDir' inside the coding, just before the
> > open or just after the open of the connection - still nothing.
> >
> > I would really appreciate any assistance, as my application has been
> > deployed over a WAN and the performance (especially initial database
> > connect) is terrible.... and the whipping boys are out to get me!
> >
> > Best regards
> > Brian Culverwell
> >
> >
>

Thanks for the reply - does not really help me though - you are describing a working situation using the things I have tried - but it just does NOT create the sub-folder at all. I am running on vista - but using a public folder (c:\temp) so permissions are not an issue.

One other poster had a very similar issue, and it was solved by some example sent by Harold Klopper? That I am sure would help me.

Also as an aside, does anyone know if using the schema cache (from 2nd connection onwards) improves the speed of the actual connect? And by how much?

Best regards (and getting desperate)

Brian