SQLSelect into an Array

[Ruslan Zasukhin]

On 9/12/09 11:51 PM, "Barry G. Sumpter" <barrysum at bigpond.net.au> wrote:

Hi Barry,

> Hi all,
>  
> Is there a way in Valentina to retrieve a Select Query Record Set straight
> into an array?
>  
> I¹ve got a static recordset of about 750 records that I need to loop thru
> about 1000 times.
>  
> So instead of reading the db 750,000 times or looping thru the recordset 1000
> times,
>  
> I thought moving the data into an array would be faster.
> Would looping thru an array be faster?
> Or is looping thru vCursor just another type of an array?
>  
> At the moment I only need 3 fields:  RecID, SequenceID, and EvenName.

No need to copy it in arrays, than more that you need 3 fields.

Just SELECT only these 3 fields, and you will be fastest.

This is because Valentina is columnar DB.

Described in WIKI and its Articles sections.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]