[odb-users] using ODB for interactive access

[Panayiotis Georgiou]

Hi Boris,

The timings I have mentioned are for 1000 calls to each function. A single
call to rowCount() performs a "select all" query, and a single call to
data() performs a "select all" query and then returns the N-th record from
the query result.  So a single call to each of this functions takes less
than ~0.2ms. Is this still too high?

Thanks.

On Wed, Nov 8, 2017 at 12:49 PM, Boris Kolpackov <boris at codesynthesis.com>
wrote:

> 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
>
>