Maciej Sobczak <[email protected]> wrote:
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
Thank you, Maciej. I will have a read.
Simon
------------------------------------------------------------------------------
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
