Cursors are the best thing about VFP!!! When the bus hits me and you
take over my work, you'll see that I use VFP cursors EVERYWHERE to be
the conduit between the app and the MySQL backend.
Anytime you can use a CURSOR instead of a TABLE, do it, and most likely
you'll notice a performance difference.
Thanks,
--Mike
On 2014-07-10 18: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!
--
Jeff
Jeff Johnson
[email protected]
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
[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.
