Hi

I have a customer with have an DB that supports 20 clients.
15 of those clients connects through an ADSL line to a terminal
server in the head office.
Here they run our program which connects to a DB on another server.

Since marts 2002 and until december 2002 it ran perfectly.

Then our customer moved the head office location.
When this happened the Internetline at the head office of course
changed.
They got a ZyXEL Router instead of a Cisco i.e.

Now the clients keep falling of every once in a while.
And the system has dropped considerable.

First I assummed, that I had created to many index' on to many tables.
So laft week i drop a lot of index' on the DB.
Now every table contains no more than 8 index'.
Most of the tables only contains 4 index'

Those 4 are always created as 2 asc and 2 desc (on two different
fields).

We have been pinging the clients router at the new location, and
every once in a while the respons time from the router is not
available.
I Think thats why the are being trown off.

Now my theori goes on this:

1 clients is about to do an update, and therefor starts an
transaction.
The connection to the terminal server goes down.
After a few seconds the session is terminated, by both server and
client.
And after another few seconds the firebird DB realizes that the
connecton has been lost and rollbacks whatever transactions are
active (Does anyone know how long time there will go) ?

Until this happens, all other clients that wants to update / insert
on the same tables must wait (they get a Deadload on no wait
transaction).


So I think that the poor quality of the internet line causes this.
Is that likely to be the case ?

Or Could it be anything else ?
Still to many index (which I find very unlikly since we here in our
own house havn't the same problems with the same software / DB).

Other things ?


Regards
Michael