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?
On 7/10/2014 3:30 PM, Kevin Cully wrote:
There are circumstances where if your SELECT to create the cursor
exactly matches an index, VFP is so smart that it basically does a SET
FILTER into the cursor, instead of creating a true independent cursor.
You can see when this is the case by using the DBF() on the selected
'cursor'.
To override this, after your SELECT ... INTO CURSOR make sure to add
the NOFILTER clause.
HTH,
Kevin
On 07/10/2014 06:26 PM, Jeff Johnson wrote:
Andy, what's that mean? I can't rely on that? I did not set an
order in the cursor.
On 7/10/2014 3:25 PM, AndyHC wrote:
Not all cursors are born equal!
On 10/07/2014 23:13, Jeff Johnson wrote:
I replaced a table with a cursor in the VMP framework to improve
performance. I noticed that all of the index tags worked on the
cursor and I thought something was wrong. In the command window I
created a cursor on a table and browsed it. Then I set an index
tag and browsed it and it was in the index order. Set another and
likewise!
Is this just something I did not know about?
Anyway, it is totally cool!
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
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/53bf160d.1080...@san-dc.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.
