JDBC performance comes for free with our pooling DataSource classes:

  • AtomikosDataSourceBean for XA-enabled JDBC, and
  • AtomikosNonXADataSourceBean for non-XA enabled JDBC

However, you do need to make sure that you respect the following guidelines:

  • Close connections as soon as you no longer need them. Note that in the case of pooling, close does not mean destroy. Rather, and thanks to our pooling, this will allow reuse of the connection at the earliest convenience.
  • Set the poolSize to something that is adequate for your needs. Start with a small pool and increase its size while measuring performance under realistic concurrency loads (number of concurrent threads, …). In general, performance will improve as you make the pool grow, until the point where increasing the pool's size does not have any effect any more. That is probably the pool size you want…
  • Make sure that the transaction timeout is set to a reasonable value - exactly what value depends on the expected time needed by your SQL: if you set the transaction timeout to a lower value, then most of your SQL statements will expire and rollback.

最新文章

  1. git pull 冲突解决
  2. C# 只移除最后一个字符
  3. MSSQL PIVOT 实现行列转置
  4. 经典DOS游戏皇帝攻略(曾经的回忆)
  5. zookeeper 安装与配置
  6. Objective-C Polymorphism
  7. HTML的盒子模型
  8. (转载)MonoBehaviour的事件和具体功能总结
  9. php变量那些事:php引擎对变量声明、存储简要分析(ZVAL)
  10. T430 Windows 8 的USB3.0无法识别
  11. BZOJ_3172_[TJOI2013]_单词_(AC自动机)
  12. java InputStream
  13. Urlparse模块
  14. 白盒测试实践-day03
  15. android根据图片路径显示图片
  16. 每日英语:Google Scraps Plan to Build Hong Kong Data Center
  17. Python3基础 函数 有参数有返回值 对传入的参数加1
  18. 序列化和反序列化(json 和pickle)dumps 为序列化, json为反序列化
  19. 26-[Boostrap]-全局css样式,组件,控件
  20. e665. 在图像中过滤三元色

热门文章

  1. 微信小程序设置滚动条
  2. docker-compose EFK查看docker及容器的日志
  3. Python 中的 -> 是什么意思
  4. Redis操作类型
  5. js的Map实例
  6. ALV显示金额字段值扩大100倍
  7. DELPHI中 screen.Cursor:=crhourglass; adoQuery.close; adoquery.Open; screen.Cursor:=crdefault;啥意思
  8. spark osx:WARN NativeCodeLoader:62 - Unable to load native-hadoop library for your platform
  9. laravel5.2总结
  10. ubuntu18.04开机提示welcome to emergency mode! after logging in type...的解决办法