[odb-users] Using prefetch with Oracle

Marco Craveiro marco.craveiro at gmail.com
Mon Feb 13 05:25:38 EST 2017


Boris,

<adding OCI_ATTR_PREFETCH_ROWS>
> 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?

Cheers
-- 
Marco Craveiro

MD, Domain Driven Consulting
about: http://about.me/marcocraveiro
blog: http://mcraveiro.blogspot.co.uk
twitter: https://twitter.com/MarcoCraveiro

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]. --
Alan Key
-------------- next part --------------
A non-text attachment was scrubbed...
Name: prefetch.patch
Type: text/x-patch
Size: 1194 bytes
Desc: not available
Url : http://codesynthesis.com/pipermail/odb-users/attachments/20170213/63f637f3/prefetch.bin


More information about the odb-users mailing list