I have an application on weblogic server using sybase database. It execute select query , get some data , manipulate it and update/insert into another table.
But the inserting / updating is very very slow like it adds one row in 40 seconds on avg.
table is very huge and we have indexing also.
Btw the same application runs very fast on another server (Sybase EA server) so I dont understand what is the problem. it cannot be a database problem since it runs so fast on EA server. Only running on weblogic creates a problem.
Weblogic is supposed to be faster than EA server i thought. Please help me with this. It is pretty critical.