JDBC update takes forever.
Hi Experts
I have an application runnng on an as/400.
I connect to the SQL server data base and get a record that I want to update as "processed"
When I try to perform the update the system simply hangs and all other users start to time out.
I have an index over the file by the key I am trying to update and when I run a select query in enterprise manage it takes sub second.
the update statemnt is
Update CpArchiveIndex set Tba = '2011-01-01'
where ARC_DOCNAME ='a0d2ab215f676c4c8bcde9d6
ARC_DOCNAME is defined as 255 varchar null not alowed.
any ideas
Dave
I have an application runnng on an as/400.
I connect to the SQL server data base and get a record that I want to update as "processed"
When I try to perform the update the system simply hangs and all other users start to time out.
I have an index over the file by the key I am trying to update and when I run a select query in enterprise manage it takes sub second.
the update statemnt is
Update CpArchiveIndex set Tba = '2011-01-01'
where ARC_DOCNAME ='a0d2ab215f676c4c8bcde9d6
ARC_DOCNAME is defined as 255 varchar null not alowed.
any ideas
Dave
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi
I can run the updates via a VBA application using the same update string.
dave
I can run the updates via a VBA application using the same update string.
dave
ASKER
tidy up - I would like to get to the bottom of it evebntually.
ASKER
Yes I have an index on Arc_Docname
No there are not ay triggers
dave