Hello Mike, On startup, there are 45 free tables opened.
The mini-close routine closes 9 of the most used tables and reopens them. We have options to do a full close, mini close or nothing and leave the tables open. The full close takes too long, so that is the reason for the mini-close. -----Original Message----- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB Software Solutions,LLC Sent: Wednesday, September 07, 2011 11:20 AM To: ProFox Email List Subject: Re: Error 1104 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 [excessive quoting removed by server] _______________________________________________ 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/DA285463B011482C81F443D2BCE612EC@LaptopW7 ** 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.
