When using a cursor, "CREATE INDEX field TAG tagname" creates a temp CDX on the local drive and when you close the cursor the temp CDX goes away on its own.
-----Original Message----- From: Kurt Wendt Sent: Wednesday, March 24, 2010 5:15 PM 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- _______________________________________________ Post Messages to: ProFox@leafe.com 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/001001cacb9a$5a1750c0$0e45f2...@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.