On 3/1/07, Vassilis Aggelakos <[EMAIL PROTECTED]> wrote: > > ... doesn't sound very efficient. > > Do you have any (good) ideas?
It's always worth benchmarking a solution before you go to a lot of trouble to construct a more complex solution that turns out not to save you any time or resources whatsoever. That's "premature optimization." That said, I've solved this in the past by creating a temp file on the remote server, uploading the 50 local records to the temp table, then doing the join on the remote server and downloading the result. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ 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 ** 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.
