Subject | RE: [IBO] IBOQuery Prepare |
---|---|
Author | Marv cook |
Post date | 2004-07-27T20:54:36Z |
-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
<snip>
Another route would be to use a schema cache file so that instead of
getting the information it needs from the server it will just pull it
out of a local text file. This is a property on the TIBODatabase
component or TIB_Connection component.
</snip>
Certainly speeded it up. Login time went from about 10 seconds to about
2 seconds. Doesn't sound like much, but makes system much more
acceptable to the user.
I am not sure I understand exactly how to use it and the help file was
not too clear.
If I set the IB_Connection.SchemaCacheDir := <Some Directory> it speeds
up the process but I get a exception in the debugger complaining that
the IBO$SCHEMA_VERSION table is not available (which is caught and does
not stop the program from executing) If I use IB_Connection
.schemacache.checkschemaversiontable the table is created and the run
time break stops, unless I execute the Checkschemaversiontable function
again, then I get a break complaining the table is already available.
How are you supposed to use the process?
Thanks for you help.
Marv
From: Jason Wharton [mailto:jwharton@...]
<snip>
Another route would be to use a schema cache file so that instead of
getting the information it needs from the server it will just pull it
out of a local text file. This is a property on the TIBODatabase
component or TIB_Connection component.
</snip>
Certainly speeded it up. Login time went from about 10 seconds to about
2 seconds. Doesn't sound like much, but makes system much more
acceptable to the user.
I am not sure I understand exactly how to use it and the help file was
not too clear.
If I set the IB_Connection.SchemaCacheDir := <Some Directory> it speeds
up the process but I get a exception in the debugger complaining that
the IBO$SCHEMA_VERSION table is not available (which is caught and does
not stop the program from executing) If I use IB_Connection
.schemacache.checkschemaversiontable the table is created and the run
time break stops, unless I execute the Checkschemaversiontable function
again, then I get a break complaining the table is already available.
How are you supposed to use the process?
Thanks for you help.
Marv