Hi Derek,
I'd say most experts would never put 100k records in a grid, ever. GUI
controls aren't designed for this amount of data typically, and it's
fairly un-usable to end users.
Maybe I wasn't so clear. I didn't want to display 100K records in a grid.
I have a small cursor with 50 records
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
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
On 3/2/07, Vassilis Aggelakos [EMAIL PROTECTED] wrote:
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
Hi folks,
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
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
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
7 matches
Mail list logo
