Hi

I have made an appl. that is a point of sale.
When a client do a sale (i.e. 3 things are being sold) then I do this:

1.
Update a record with the amount sold.

2.
This record does an update on 12 tables (through trigges).

3.
Then I do an update on another table with the value of the sold items.

4.
This update does an update on 2 other tables (through) trigges.

5.
Then I insert somewhere between 8 and 40 records in a table with
somewhere around 40 index on.


Now
My customer complains aboout speed.
I have recently created those 40 index. Before there was only 4.

Could those 40 index cause the system to slow down significantly ?


The other thing I have in mind is, that my gab between oldest
transaction and next transaction is somewhere around 2000.

I think its one of the above that causes the slow update, but can I
tell which is more likely to do that ?

Besides, I think some of the clients have come to a habbit of opening
some windows, without closing them again.
So now I'm I have started to change my appl. to close after 10 minuts
idle time.

Regards
Michael