[odb-users] Network speed issue

Sten Kultakangas ratkaisut at gmail.com
Sun Sep 17 15:37:59 EDT 2017

Hello Boris

On Sun, Sep 17, 2017 at 8:06 PM, Boris Kolpackov <boris at codesynthesis.com>

> Hi Gilles,
> Specifically, I would suggest that:
> 1. You create a single instance of odb::database for the lifetime
>    of your application.
Does instantiating odb:database involve creating new connection ?

> 2. Batch as many database operations into a single transaction as
>    reasonable since every transaction begin/commit is a network
>    roundtrip.

There are many situations where reading data from different tables using a
single transaction is a costly operation from the database's point of view.
Is it possible that in future versions of ODB operations such as db->query
do not require an open transaction ?

Best regards,
Sten Kultakangas

More information about the odb-users mailing list