it's not hardware,
it's not same user
it's not db size,
it's not number of users,
it's not backup and restore (your regime is over the top)
don't bother rebuilding the db (my recommendation)
please confirm,
you have a clean new app, stuck a IBDatabase connection on it, set the
database name, added a default transaction, set the params for logon and
don't prompt for logon screen, you have the right dialect set?
and double clicked connected... and it takes 10-20 seconds? Is that what is
going on?
if this is correct, could you show us the database name string?
Alan
-----Original Message-----
From: Gerhard Knapp [mailto:prometheus@...]
Sent: Thursday, 22 August 2002 10:58
To: ib-support@yahoogroups.com; ib-support@yahoogroups.com
Subject: Betreff: [ib-support] Re: Interbase v6.01 S-L-O-W on disconnect



hi all,
i have allways not solved my problem of very long connection time ..
to connect the db i need 10 till 20 seconds ...

i tried all, what is possible ...
-> connect with ip-number p.e.: 10.10.20.2 (but its no diffrence, DNS
works
good in my lan)
-> slow connection ist the same with: IBO, IBX, BDE ....
and so on and so on ....

if the db is connected, the rest goes in normal time ...

Perhaps its the DB itself?
This DB is a 1GB DB and has 30 concurrent users, with high-updating ...

(i make daily backup and restore, to hold the db fresh ..)

all my applications connect the db with one user: p.e.: DBUSER,
so i have 30 connections with DBUSER, is that a problem?

I know there are a lot of parameters and so on, but i tried all settings,
that could
be important. No i think i create a new DB and try to bump the data from
the
old DB in the new one. Perhaps this helps ... But its a lot of work!!!!

Do you have an idea, how i could do this?

I also changed the server. Now i had a 6 times faster one.
But the slow connection is the same.
I use Cisco switches in my lan, the best what i know ..
No port-errors, and server and switch have only few network traffic ...

perhaps anybody had this problem solved ...

(I use Firbeird 1.0 Superserver, winNT 4.0, SP6, IBO, the server has 1GB
memory, and 2 GHz speed, the hd is a 7200 rpm one, 80 GB, the netcard is a
100 Mbit with Realtek-Chipset, very fast normally)


best regards
-gerhard





-------Original-Nachricht-------

Von: ib-support@yahoogroups.com
Datum: Mittwoch, 21. August 2002 21:52:18
An: ib-support@yahoogroups.com
Betreff: [ib-support] Re: Interbase v6.01 S-L-O-W on disconnect

KevinHerrmann wrote:

> Recently, our app using Interbase v6.01 began to get S-L-O-W on
> disconnect. I have checked google web and groups for help but came up
> with something similar that seemed to fix itself.
> ...

Are the disconnects slow on the LAN as well?

My first guess would be "this is what you get for using BDE + TTables +
Internet".
I've seen slow disconnects, but these were reaaaaally slow - caused by a
sweep thread kicking in, I assume.

I haven't used IB/6.01 myself (just IB/5.6 and Firebird) - maybe you
should
make sure you are using the latest version as early IB/6.01 had serious
problems.


Regards,
Aage J.



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



.

[Non-text portions of this message have been removed]


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]