Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

[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