On 9/7/2011 9:29 AM, Kent Belan wrote: > Hello Alan, > > Yes, all the EXE's are the same. > > I do that for sending emails. I add the emails to a queue and another > program reads the que and sends the emails. > > I can't do that for this part of the job because I can get many transactions > coming in at the same time and have to process them and return the answer as > fast as possible. Since VFP is not multi-threaded, the only way I could get > this to work is have a VB program sit in front of the VFP programs and act > as a traffic cop. > > This setup is working great and as the client grows, he can add more > computers to split the load. Currently we have 3 computers running a VB > traffic cop and about 5 to 20 VFP programs on each one. > > Even better news, we have had an no 1104 errors since last Friday when we > turned on our mini-close routine.
You need to get MTS - Microsoft Transaction Server: http://en.wikipedia.org/wiki/Microsoft_Transaction_Server LOL Tell me again about your "mini-close routine?" -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4e678b8e.9000...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
