@Maciej Sobczak
Thanks for helping me out, well i need to put all the data in my table(3
columns) into a vector
so that i could manipulate it ... speed (throughput) is the most crucial
requirement here.
As mentioned with 1 billion entries the vector method works. Unfortunately with
2 billion
the vector method wont work because i get an allocation error which means that
the availability of space for vectors
has run out...Is there a work around for this ??
What i really want is inserting all the data of my table into a container with
maximum throughput...
Unfortunately it seems that vectors wont even do the trick and i am only left
with rowset (which actually doesnt really populate any container)... I guess
you know what i am trying to do now... any suggestions would be appreciated..
> Date: Fri, 29 Oct 2010 09:54:08 +0200
> From: [email protected]
> To: [email protected]
> Subject: Re: [SOCI-users] Fastest container using Soci Help??
>
> 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
>
> ------------------------------------------------------------------------------
> Nokia and AT&T present the 2010 Calling All Innovators-North America contest
> Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
> http://p.sf.net/sfu/nokia-dev2dev
> _______________________________________________
> Soci-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/soci-users
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
