Updating Hibernatejjdbc Batch and Fetch Size

Hi,

I was wondering if anyone had ever increased the hibernate batch size and/or hibernate fetch size of the jdbc? If so, how was this done and what was the impact on your system?

We are getting some socket timeouts and were looking to improve this. we though increasing the hibernate batch size and/or hibernate fetch size may help based on this: https://stackoverflow.com/questions/18014539/connection-exception-fetching-large-data-from-mysql 

 

Thanks,

Rachel

  Discussion posts and replies are publicly visible

Parents
  • Adjustments to hibernate settings may potentially impact product behavior.
    Consider contacting Appian support to find out how they feel about supporting a system in which this setting has been changed.

    Can you tell us more about your use case?
    With better insight into what you're trying to do, perhaps the community will have some suggestions on how to satisfy your requirements without customizing hibernate.
Reply
  • Adjustments to hibernate settings may potentially impact product behavior.
    Consider contacting Appian support to find out how they feel about supporting a system in which this setting has been changed.

    Can you tell us more about your use case?
    With better insight into what you're trying to do, perhaps the community will have some suggestions on how to satisfy your requirements without customizing hibernate.
Children
No Data