Hi Derek, Thank you for answering. >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...
The resulting cursor will be used as recordsource in a grid. Until now I used to download all the records from the big table locally and then I was doing an inner join, but I would like to ask what the experts do in a common scenario like this. Vassilis ----- Original Message ----- From: "Derek Kalweit" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, March 01, 2007 10:40 PM Subject: Re: How to join a local and a remote cursor? >> 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 > > [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.
