Re: [SOCI-users] Fastest container using Soci Help??

[Maciej S. <pr...@ms...>]

Hello,

On 10/28/2010 9:52 PM, Hayyan Rafiq wrote:

> 1) does the rowset container gets completely populated so quickly ??

No. The rowset is not even a container, it is an iterator to the result 
of your query. No data is transmitted (except maybe for some prefetch) 
until you ask for it.
So, it seems to be available "quickly", but certainly will take more 
time to actually read all data.

> 3)Suppose there are 10 million entries in my DB what would be the
> fastest way to lad them up ???

Vectors provide the fastest way to transmit arrays with Oracle, since 
they use direct mapping and the data is being transmitted in one block 
directly to the vector's buffer.

Now the question is: what do you really need? Do you need to start 
displaying the data as soon as possible, or to get everything as soon as 
possible? Both make sense in different situations.
I think that rowset will be more useful in interactive (GUI) scenarios, 
because it can make the impression of lower latency, whereas vectors 
will work better in batch processing, where not latency, but total 
throughput is of highest importance.

Regards,

-- 
Maciej Sobczak * www.msobczak.com * www.inspirel.com