On 12/28/2011 9:14 AM, Lou Syracuse wrote: > I have the same issue with a .NET program, so it is not limited to VFP. It > calls a StoredProc in SQLServer that takes an hour to run. > > I was thinking about creating a 'job' table.. get the ID and pass it along > with the parameters to the Stored Proc from a second EXE (called from the > first with its visible property set to false). The 2nd exe calls the SP then > updates a completed field in the job table... meanwhile the original program > is sitting in a form with a timer that checks that flag every 60 seconds or > so and when it is set does a query to pick up and delete the data from a > 'results' table based on that job id. > > Clear as mud? It seems like overkill for a process that we only run once a > day though. Parameters need to be entered so it can't be automated. Would > have been better (and much easier to debug) doing the work in .NET, but the > IT Manager (non-programmer) said to do it in an SP so it can utilize his > new/expensive/fast server. Someday when I have time I'm going to code it in > .NET to see if there is really that big of a speed difference. I think I have > some time opening up in November 2014... > > Lou
I did the same kind of thing back in the late 90s, creating a "print server" that helped kick out reports quickly. Left inside the app, it bogged things down horribly. Later, after I'd already completed it, saw someone else post a similar solution in FoxPro Advisor. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
