[odb-users] Using prefetch with Oracle
marco.craveiro at gmail.com
Mon Feb 13 05:25:38 EST 2017
> Just to confirm, did you hack select_statement::execute()?
Aha! I must have changed it in the wrong place! :-) I re-did my change
as I had reverted it but this time I made sure it was on
select_statement::execute(); I can now see a massive difference in
performance (~5x faster cold). Quick hack attached.
I'm going to have a look and see if I can follow the same pattern for
the bulk parameter so that it uses the pragma value when setting the
prefetch (and does nothing if bulk is not set). If I do this, would
you accept it as a patch?
MD, Domain Driven Consulting
That the Ideas are themselves manifestations (of the Idea-Idea) and
that the Idea-Idea is a-kind-of Manifestation-Idea—which is a-kind-of
itself, so that the system is completely self-describing— would have
been appreciated by Plato as an extremely practical joke [Plato]. --
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 1194 bytes
Desc: not available
Url : http://codesynthesis.com/pipermail/odb-users/attachments/20170213/63f637f3/prefetch.bin
More information about the odb-users