By the way - thank you ALL for your input on this - as usual - ProFox ROCKS!
So - Mike - sorry if this sounds like a clueless question (but, I'm also under a crunch to finish this program update) - but, I've never heard of an Index specific to a Cursor. Although, I suspect you do NOT Mean ORDER BY when creating a Cursor using SELECT. After doing some quick searching in the VFP online Help - I see the UNIQUE option within the CREATE CURSOR - SQL Command. Is THIS the Index that you are referring to? Sorry to admit I haven't really worked with doing Indexed Cursors. But, it sure seems that it MUST be the route I follow for this problem of mine. -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, March 24, 2010 5:17 PM Richard Kaye wrote: > 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. I agree with RK. VFP will handle your 3000-record cursor just fine with its own temp indexes. Do NOT use the IDX indexes as you had in the past. Just use a CURSOR and indexes with it for simplicity's sake. -- Mike Babcock, MCP _______________________________________________ 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.
