I ran into a situation like this where that one form was the
"Distributed Pending" form. We had a situation where there were
three application servers initiating between 750k and 850k DSO
transactions a day. During peak times, the UPDATE ARSCHEMA SET nextId
= nextId + 1 WHERE schemaId = ><"Distributed Pending" SchemaID>> was
causing significant lock contention at the database level.
We ended up setting the Next-ID-Block-Size parameter to 25 and used a
Push Fields action to create a record in a form entitled
"APP_DistributedPendingTransactions". We have four separate
escalation threads running against the
"APP_DistributedPendingTransactions" form and pushing data into the
"Distributed Pending" form. We had to take this route because the
'Next-ID-Block-Size' parameter works for every form EXCEPT
"Distributed Pending".
The response from BMC support was less than encouraging. They asked
us why we needed to DSO so many records and it was recommended that we
try an alternate replication technology. We're still using DSO
because our work-around performs exceptionally.
If your mystery form is NOT "Distributed Pending", then I'd try
setting the Next-ID-Block-Size parameter.
Derek
On Nov 4, 2009, at 1:39 PM, William Rentfrow wrote:
**
Listers...
I was helping a person who contacted me look at a performance
problem. I do not have access to the system.
It appears the update to ARSCHEMA that is called by the CE API call
is taking forever for just ONE record. In other words when this
executes:
UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = xxx
...it works fine for all but 1 row. Most rows complete in 0.01
seconds or less. The troublesome row update can take 90 seconds or
more.
I've never seen that. Has anyone else? I thinking rebuilding the
indexes on that table is the first thing to try.
William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com
Blog, www.williamrentfrow.com
715-410-8156 C
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
