IxiRancid Posted December 13, 2005 Posted December 13, 2005 Can I omit the "wait-time" when I run a Stored procedure? The thing is, my procedure goes on for 20mins, and thus I usually get timeout expired or the user falls asleep and does strange things. I imagine that the application is waitting some out parameters from the server system or what? Can that be omitted? Quote
mike55 Posted December 13, 2005 Posted December 13, 2005 Are you sure that your procedure should be running for 20 minutes, seems like a pretty long time? Mike55. Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
IxiRancid Posted December 13, 2005 Author Posted December 13, 2005 It's a DB2 stored procedure, but actually I figured something out. I got this project unfinished from a collague. He use ADODB conection and pass a SQL call statement. This often took more than 20mins and got Timeout Expired. Now I used CWBX (IBM as400 dll) and just pass this call to the server. Don't know really how it connects to the server, but the thing is now faster. It runs approximately 3mins. Which of course is acceptable. And the crowd went: "ooooh". :) Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.