[odb-users] Performance issues for large sets

Quentin Deldycke quentindeldycke at gmail.com
Fri Sep 19 05:42:40 EDT 2014


Yes, but sadly they doesn't suits all my needs and limit quite much our
usage of ODB.


Our 'old' system used C-ISAM. It can perform a "while" of 1000 elements in
0.003s - 0.007s.
The same request with odb iterate this 1000 elements in 1.3s - 2.6s.

The use of odb views allows me to perform this iteration in 0.01s - 0.03s.

   - But this mode take only the data i want (i don't know exactly the user
   will need in the root object!)


The main advantage i see of views, is because they don't resolve dependency
at 'iteration' but at 'query'

While the basic way of working select data of root object at 'query' then
resolve dependency at 'iteration'.
This behavior seems to be a performance-crasher...


In fact, to be honest my main problem is the 5 select i have by iteration
on my query...
I don't care i the select takes 20seconds, but this traffic of request is
too much high...

--
Deldycke Quentin


On 19 September 2014 09:05, Boris Kolpackov <boris at codesynthesis.com> wrote:

> Hi Quentin,
>
> Quentin Deldycke <quentindeldycke at gmail.com> writes:
>
> > You are right, the difference of performance is impressive:
> >
> >    - Without views: 50s
> >    - With views: 1.2s
>
> Yes, ODB views are awesome ;-). Thanks for sharing the numbers.
>
> Boris
>


More information about the odb-users mailing list