I've hit this wall many times, and how you handle it is largely dependant on where the bottleneck lies.
Have you logged the transaction to see if your DB is hanging on the query for the View Form, or your workflow during Filter processing, or...? Chris Woyton -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Kelly Logan Sent: Wednesday, November 15, 2006 7:43 AM To: [email protected] Subject: Large transactions Hello All, I am looking at alternatives to a current integration process that uses external .CSV files and Remedy Import called by runmacro. (We have had some issues with file permissions and runmacro.) I have set up a View form to a table with the data and added some display only fields to it for translation and workflow, the principal one being a zTmpProcess field (Yes/No). I have one filter that pushes a value of "Yes" to this field on the form for all entries (~40,000), and a set of filters that fire off of Modify to translate some of the information (set other temp fields to mapped values) before pushing it to SHR:People. The process works fine when I run it manually for 1,000 or so entries, but when I let the workflow kick off a change to all 40K, I get a database timeout. I'm considering some chunking strategies like using an SQL statement to set another flag and loop through, processing 1,000 at a time, but I thought I'd check to see if anyone else has done something similar, or if there's a simpler strategy that may be eluding me at the moment. Thanks in advance for your time, Kelly Logan Cybernetic Solutions, Inc. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
