Hi,
Sorry for posting to the developers list, I have tried all other
places dedicated to end-user support, however it seems the question is
too in-depth :/
Is it possible to disable prepared statement caching for batched
fetching, so I end up with a single query in the <
default_batch_fetch_size case only instead of the fixed-size batch
loading hibernate does by default?
If its not configureable, I would be really grateful for a pointer to
the source where that caching and sub-batch-by-sub-batch loading is
done.
I am latency bound with a low-loaded postgresql-server, so I would be
happy if I could trade lower server load with less roundtrips.
Thank you in advance, Clemens
Show replies by date
Hi,
Because of the lack of feedback, I decided to start hacking blindly ;)
Generating the Loaders on demand broke for an unknown reason, so what
I do now is to pad the batch-load request with non-existant primary
keys up to the next larger batch-size and distribute the batch-sizes a
bit more uniform.
Works great so far - for my use-cases I almost always get only one
query - so I get almost the same amount of roundtrips as with
SUBSELECT fetching, only with a lot less complex queries.
If there is some interest, I would be happy to share the patches.
(although its quite hackish, not ready for general consumption)
Thanks, Clemens