> > 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? Ah-- you're performing aggregate functions on the 100k records(such as count, sum, etc.)? I would be surprised if the temporary table option isn't the fastest in that case... -- Derek _______________________________________________ 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.
