Thanks Dave. The odd thing is that later it worked fine. I'm going to have to test it some more. Something was slowing it down.
----- Original Message ----- From: Dave Crozier <[email protected]> To: ProFox Email List <[email protected]> Cc: Sent: Wednesday, September 4, 2013 6:57 AM Subject: RE: Why would this be faster in IDE? Also, could it be that the dev system has the tables open already and cached so that the select becomes a process reading from cache as opposed to disk. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Michael Madigan Sent: 04 September 2013 09:13 To: Pro Fox Email List Subject: Why would this be faster in IDE? If I run this code in a command button while inside the development package it runs quickly If i run it stand alone using the runtime support files, it runs really, really slow. Just this code Any idea why? memacct_id=ALLTRIM(debt.acct_id) memrand3=SYS(2003)+'\payment' memrand2="c:\foxprow\"+SUBSTR(SYS(2015),1,8) SET SAFETY off select * into TABLE &memrand2 from &memrand3 where; payment.acct_id=memacct_id SELECT payment DELETE ALL APPEND FROM &memrand2 SET SAFETY on SELECT debt thisform.refresh[excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
