[odb-users] Network speed issue

[Sten Kultakangas]

Hello Boris

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

> 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