On Fri, Aug 10, 2012 at 9:33 AM, MB Software Solutions, LLC <[email protected]> wrote: > VFP9SP2 > > I've got a temporary cursor that I manipulate and then need to return a > cursor to the calling routine named what was requested (via parameter). > Would it be quicker to do USE MyTempCursor AGAIN IN 0 ALIAS > MyDesiredCursorName or do a SELECT * FROM MyTempCursor INTO CURSOR > MyDesiredCursorName? >
Well, to quote our good friend Ed, "it depends"... Have you benchmarked it or tested it to see which is faster? Also remember that over time, or for big vs small files/cursors, then answer could be completely different i.e. change on you depending on circumstances. -- Matt Jarvis Eugene, Oregon USA _______________________________________________ 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/capt54rynpalqejyhtyngmxy0xypkq2oglg5w8vwvqyguyf1...@mail.gmail.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.
