LS

What exactly happens when a database opens. Are all the tables opened? I
have a remote database. When in EDBmngr I open the database it takes a
while. Opening the tables however is instant. Or is this EDBmngr behaviour?

Regards, Harry

Forget to mention:
-connecting the session takes 2 a 3 seconds.
-the database opens after 40 seconds!

I am used to dbisam local via kbmmw middleware and there it takes one second
total! Alas I can't use EDB local with kbbmw because of the problems there
(see my other post). I thought I maybe should replace that solution with EDB
C/S but I cannot  have visitors of my customers's websites wait that long. I
still wonder if it's me or my settings that's all causing this. All and all
this isn't cheering me up

Regards, Harry


"Harry de Boer" <harry@staaf.nl> schreef in bericht
news:7D457A6D-07EA-4F9C-9BCE-5A69C4D21049@news.elevatesoft.com...
> LS
>
> What exactly happens when a database opens. Are all the tables opened? I
> have a remote database. When in EDBmngr I open the database it takes a
> while. Opening the tables however is instant. Or is this EDBmngr
behaviour?
>
> Regards, Harry
>
>

Just wrote a little testapp thet connects to the remote db and the database
opens instantly! No slowdown at all!

Tim, Is there something that is slowing down the EDBmngr?

Regards, Harry


"Harry de Boer" <harry@staaf.nl> schreef in bericht
news:641EB217-BE34-4CB1-AAFE-A5D150E27195@news.elevatesoft.com...
> Forget to mention:
> -connecting the session takes 2 a 3 seconds.
> -the database opens after 40 seconds!
>
> I am used to dbisam local via kbmmw middleware and there it takes one
second
> total! Alas I can't use EDB local with kbbmw because of the problems there
> (see my other post). I thought I maybe should replace that solution with
EDB
> C/S but I cannot  have visitors of my customers's websites wait that long.
I
> still wonder if it's me or my settings that's all causing this. All and
all
> this isn't cheering me up
>
> Regards, Harry
>
>
> "Harry de Boer" <harry@staaf.nl> schreef in bericht
> news:7D457A6D-07EA-4F9C-9BCE-5A69C4D21049@news.elevatesoft.com...
> > LS
> >
> > What exactly happens when a database opens. Are all the tables opened? I
> > have a remote database. When in EDBmngr I open the database it takes a
> > while. Opening the tables however is instant. Or is this EDBmngr
> behaviour?
> >
> > Regards, Harry
> >
> >
>
>

Harry,

<< Tim, Is there something that is slowing down the EDBmngr? >>

Yes, it has to load the metadata for the entire database when you open it.
That can take some time, especially if there are a lot of database objects
in the database and the connection is slow.  How many tables and other
objects (approx) are in the database ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Yes, it has to load the metadata for the entire database when you open it.
> That can take some time, especially if there are a lot of database objects
> in the database and the connection is slow.

Ok. Well, the connection is not slow at all (query results are back in a
wink). And with a local session (same db on my pc) it opens instant. I think
that 40 sec is a long time, but I'm honest enough I don't know what reading
metadata exactly means in terms of speed.

> How many tables and other objects (approx) are in the database ?

Just 45 tables.

Like I said, my testapp runs fast, and that's great. A bit worried though if
I need some metadata myself (eg building a list of tables for a picklist).

Regards, Harry





"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:F47845DB-A46D-44C1-93B6-6108C15FC2DC@news.elevatesoft.com...
> Harry,
>
> << Tim, Is there something that is slowing down the EDBmngr? >>
>
> Yes, it has to load the metadata for the entire database when you open it.
> That can take some time, especially if there are a lot of database objects
> in the database and the connection is slow.  How many tables and other
> objects (approx) are in the database ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Harry,

<< Ok. Well, the connection is not slow at all (query results are back in a
wink). And with a local session (same db on my pc) it opens instant. I think
that 40 sec is a long time, but I'm honest enough I don't know what reading
metadata exactly means in terms of speed. >>

It basically means that it needs to perform the queries necessary to read
all of the tables, their columns, indexes, triggers, etc. along with any
views, procedures, functions, etc.  It can take some time depending upon the
number of columns in the tables.  However, the main reason for the slowdown
is the navigation of the query result sets and the creation time for the
treeview nodes, not the queries themselves.

<< Like I said, my testapp runs fast, and that's great. A bit worried though
if I need some metadata myself (eg building a list of tables for a
picklist). >>

Try it and you'll see (RequestSensitive:=True):

SELECT *
FROM Information.Tables

It should be as fast as any other simple query.  The slowness comes into
play with querying all of the sub-data under the tables.

--
Tim Young
Elevate Software
www.elevatesoft.com