--- 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

open

> anything. It would help if you could find out if any error is

getting

> thrown...for example, what happens when you try to Open on a dead

connection?

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

What

> 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
> www.ibobjects.com