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
