Thanks Ted, > 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,
Definetly I have to benchmark this. As a third option I have thought to create a mechanism to scan these 50 records and to hit 50 indivindual queries in the server and then to create a local union select with all these results. What about this? Vassilis ----- Original Message ----- From: "Ted Roche" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, March 01, 2007 11:01 PM Subject: Re: How to join a local and a remote cursor? > 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 > > [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 ** 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.
