On Thu, Jul 10, 2014, at 11:39 PM, Jeff Johnson wrote: > Hey Kevin! The purpose of using a cursor instead of a table is using > filters on a 20,000 record table. Does the NOFILTER affect > performance? Or is it still a cursor?
Sometimes, indexes permitting, VFP will be clever and instead of creating a new cursor will just re-present the table with a filter set in a new work area. Back in the day this would potentially be faster. NOFILTER just forces it to always create a cursor. In the normal way that cursor then may or may not have a presence on disk. _______________________________________________ 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.
