Hey RK - yes - that was the answer I was after - that Cursors should be MUCH faster!
The Record size of my records for the Cursor is small - only like 10 fields or so - and no Memo fields! AS for creating the Index - I simply create the Index as a Temp IDX file - right? Do you think it will slow it down the with IDX file actually residing on the Server (in regards to the standards I mentioned in my previous reply)??? As for Ted - yes, I WILL have a big Order/Invoice to properly Stress Test with! -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Richard Kaye Sent: Wednesday, March 24, 2010 4:55 PM To: [email protected] Subject: RE: Large # Rec's, Cursors & UR Opinion... Unless your record size is really large or involves a lot of memo fields, I can't imagine that VFP wouldn't laugh at a 3000 row cursor. A cursor can be maintained completely in memory by VFP and should be faster than temp tables. You can create indexes on cursors and the time to create and maintain the indexes would probably be saved by not having to perform table scans for each of your processes. But as Ted R. would say, you need to test your code under realistic conditions to determine the best performing code. rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: Wednesday, March 24, 2010 4:13 PM To: [email protected] Subject: Large # Rec's, Cursors & UR Opinion... I guess I could create a temporary IDX file to help me Index the Cursor (and - no - I've never done that - but, am just assuming it can be done)! Or - should I just make this thing a Temporary DBF with a Temp Index - and just forget the idea of a Cursor for this situation??? [excessive quoting removed by server] _______________________________________________ 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/289ea162f5642645b5cf64d624c66a14071a1...@us-ny-mail-002.waitex.net ** 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.
