At 19:57 2014-07-10, [email protected] wrote:
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.
Should we push for better bus service in your area?
"And drive faster. People want to get where they want to be
quickly. Besides, Mike has an exit strategy; he uses cursors." --
some transit supervisor in Mike's area?
Anytime you can use a CURSOR instead of a TABLE, do it, and most
likely you'll notice a performance difference.
I wrote reports starting before the report writer, and I prefer
my reports in code. Some of the requirements on my system can get
downright nasty, too. For a report that is not simply a dump of a
table, I build a cursor to report off.
Well, maybe more than one. For some of my more complex
reports, I have to build the reporting cursor in stages. I think my
most complicated one took about five intermediate cursors before I
finally generate the one used in the report.
I would not want to try to write the complex reports by
directly hitting the tables.
Cursors rule; cursers fool!
[snip]
Sincerely,
Gene Wirchenko
_______________________________________________
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/
** 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.
