Subject Re: [IBO] Slow connection times
Author Luiz Alves
If I remember, you need use gfix to change the page buffers to database.
Using gfix you change the page buffers to only one database and not all.

If you have a pool of open connections, it could speed up the coonection to
database once that connection already is open(I think Asta can work on this
way).

If you are executing sql statements very complicated and it is occuping many
time from server, the subsequent connections can slow down.

Another possibility is a OAT problem, if you are leaving transactions not
commited during a long time. But I have doubt if this causes any effect
during the connect.

You could investigate, as Jason said, what tib_monitor is showing to see if
there are a query taking a long time to execute immediatelly after the
connect.

These are only thoughts,

Luiz.

----- Original Message -----
From: <deavewhite@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, April 14, 2001 7:11 PM
Subject: Re: [IBO] Slow connection times


> I dropped an IB_Monitor and an IB_Profiler on my data module to
> investigate further. I also set the page buffer size to 5000 in the
> ibconfig file and uncommented this line, then stopped and restarted
> the server.
>
> If I start my application solo, the profiler reports "Num Memory
> Buffers = 75", however, if I start IBConsole before running my app,
> the profiler reports "Num Memory Buffers = 5000". I tried this a
> couple of times, running things repeated, and in different orders,
> etc. and I always get 75 buffers from my app unless I run IBConsole
> first and leave it running before starting my app.
>
> If there something in the TIBODatabase which resets the server to
> defaults if this is the only connection made?
>
> TIA
>
> Dave White
>
>
>
> --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > Hard to say. The SQL Trace monitor would reveal this if it were so.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>