MB Software Solutions wrote: > I've got a table called HOLIDAYS that lists the days the company isn't > working. I've got calls inside an iterative loop to see if a date > exists. I'm wondering if I would be better off selecting the table into > a local cursor, indexing that cursor, and then SEEKING on that instead > of the network table. I could run exhaustive tests to come up with an > answer, but wondered if others here had already experienced this kind of > scenario and could advise from their past travels? > > Other information: > - app built in VFP8 (eventually going to VFP9) > - Win XP Pro operating system on client, probably W2K or NT mostly for > servers > - favorite food: chocolate peanut butter ice cream > > tia! > --Michael >
Since it sounds like Holidays is just a lookup table, why not load it into an array at app startup? Not much diff than a local cursor, but.... Matthew S. Jarvis IT Manager Bike Friday - "Performance that Packs." www.bikefriday.com 541/687-0487 x140 [EMAIL PROTECTED] _______________________________________________ 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 ** 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.
