[REBOL] Re: Speed required
From: tim-johnsons:web at: 29-Nov-2007 9:29
On Thursday 29 November 2007, Kai Peters wrote:
> I need to transform SQL cursors with up to 10,000 records and it needs to
> be= fast:
>
> Example cursor:
>
> [
> [ 100 "Joe Browne" "Chicago" 55 445-5689 ]
> [ 101 "Joe Browne" "Chicago" 55 223-2221 ]
> [ 102 "Joe Browne" "Chicago" 55 489-5555 ]
> [ 103 "Joe Browne" "Chicago" 55 235-2245 ]
> ]
>
> I need a copy of this cursor, but only containing certain fields from each
> record;
> the desired fields should be specified in a block like:
>
> [ 1 2 5 ] if I wanted record #, name & phone from each record in the
> example above.
Hi Kai:
I'm not sure if I fully understand your need, but if you are looking
for column values 1, 2 & 5, why not compose your SQL query
to those specific columns in that order?
as in "select col1,col2,col5 from MyTable"?
If I've missed the boat here - sorry! Oh, and what
do you mean by 'transform'?
regards
tim