thanks for the help..
i removed a few indexes,
but i cant remove the primary key and uniqye key constraints ..whoch means that indexes will be made on these 2 attributes.
i have four tables, each having such 2 attributes, one which is the primary key and the other is the uniqu key.
and the insertion to these 4 tables is by means of 4 stored procedures (1 for each table).
These stored procedures are being called within a transaction ..which i begin from the application..
i noticed by putting timers that it is the "COMMIT TRANSACTION" statement to the database (after calling the 4 stored procedures) that is taking time.
but commit transaction is not slow each time, in fact it remains very small for a large number of installs ..then suddenly rises (becomes almost 8 times) and then falls again.
why such a behaviour?
thanks
regards
surabhi
