Hi, On 17/02/2012 02:09, Simon Walter wrote:
> Is there any other way with SOCI? If for example, I know a result set > will be relatively small (~1000 rows), 1000 rows is indeed quite small and there should be no risk of excessive memory consumption, so you can safely preallocate this number of elements in the vector and use that vector for query results. This should allow you to retrieve all results in a single operation and then you will be able to process all those elements according to the needs of your application. Still, whether you will get all elements in a single go or in several smaller chunks should be left to the database backend, so the recommended practice is as shown in the documentation: http://soci.sourceforge.net/doc/statements.html#bulk Please read the "Portability note" paragraph at the end of this section. Regards, -- Maciej Sobczak * www.msobczak.com * www.inspirel.com ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ Soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
