On 10/29/2010 10:23 AM, Hayyan Rafiq wrote: > 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 ??
Yes. You should use the idiom that is described in the SOCI documentation: http://soci.sourceforge.net/doc/statements.html#bulk (read everything up to "Stored procedures") Further down the page there is an example with the use of vectors of some limited size. That is, you can define your own trade-off between how much data you get in a single step (and at the same time how much memory can you invest in it) and how many steps will be needed to get everything. In my own projects I usually invest several MBs into a single batch and execute the loop as many times as necessary - above this batch size performance does not seem to improve any longer. 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
