> Let's say we have a small local cursor (50 records) and we want to join it > (inner join) with a big remote table (100K records). What is the best way to > join these two cursors? > > The obvious solution Select Col1,Col2 From BigTable into cursor > qrylocalCursor and then join qrylocalCursor with QrySmallCursor doesn't > sound very efficient. > > Do you have any (good) ideas? > > Any help would be greatly appreciated
Do you really need all 100k records? If not, then your solution is probably best-- download the records you need from the remote table, and then do a join with the two cursors-- VFP will internally not really copy the data the second time but rather internally put a filter on the original cursors, I believe, so there shouldn't be any big performance hit for a few records. Optionally, you could load the 50 local records into a temporary table on the server and do the join on the server... A little more info on how you're joining and the end need for the cursor might be helpful for us to give you more suitable suggestions... -- 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.
