[odb-users] using ODB for interactive access

Boris Kolpackov boris at codesynthesis.com
Wed Nov 8 07:49:13 EST 2017


Panayiotis Georgiou <ps.georgiou at gmail.com> writes:

> The functions affected by the implementation of our QAbstractItemModel were
> the rowCount() [counts the records in a query] and data() [reads the data
> at a particular column of a record].
> 
> * For 1000 records accessed directly from the database:
>   rowCount() - 190ms
>   data() - 160ms

FWIW, these still look rather high to me, especially if this is for an
optimized build. For comparison, running the hello example, as in, the
entire executable, which creates the database and performs a bunch of
database operations and queries -- all that takes 50ms on my machine.

Boris



More information about the odb-users mailing list