Subject Re: [IBO] IBODatabase & IBO4 1Min Query
Author danialwidner
--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@t...> wrote:
> At 01:38 PM 24-04-02 +0200, you wrote:
> >Question1: IBODatabase.Connected problem
> >
> >I am using IBO 3.4 and I had a problem where the database
connection gets
> >lost.
> No, it cannot tell when a connection is lost. All it can do is
connect and
> then, until it is logically disconnected, it remains connected.
> >Then in Code I do the following (this is not all the code, just a
> >logical idea)
> >
> >// in the beginning
> >IBODatabase.Connected := True or
> >IBODatabasse.Connect;
> Yup, that's the problem. In order for the connection status to
get back to
> normal, you'll need to call Disconnect and then call Connect again.
> If this network is liable to these types of errors, then you'd do
well to
> have some kind of fallback function that gets called each time you
> anything. It would help if you could find out if any error is
> thrown...for example, what happens when you try to Open on a dead
> >Question 2: I Min Query on IBO4
> >
> >I have tested IBO4.02 and Had a severe problem with every first
query ran
> >again a Database connection, Does not matter what type of query
you run it
> >takes almost exactly 1 min. Just for the first query and then it
flies, No
> >one else seems to have this problem, what could it be?
> At a guess, your Schemacache is updating itself upon connecting.
> do you see in the monitor?

From experience: Schemacache is updating itself on EVERY FIRST USE
OF EVERY QUERY OR TABLE as long as all other queries and tables are
closed when you do it. (IE. Open table - hit, use it, close it, open
a different table - hit... ) If you leave a small table open the hit
is on that table and the cache never gets refreshed again for the
duration of the run.

Setting the SchemacacheDir property and doing the setup for it will
also solve this.

> regards,
> Helen Borrie (TeamIBO Support)
> ** Please don't email your support questions privately **
> Ask on the list and everyone benefits
> Don't forget the IB Objects online FAQ - link from any page at