performance of bulk insert
Description
Activity
Vlad Mihalcea January 10, 2017 at 11:14 AM
There's are two HAP SANA Dialects, which have been maintained by Andrew Clemons from SAP. I think you should ask them if they want to extend the current support according to your needs.

Carsten Hammer January 10, 2017 at 11:00 AM
Hi Vlad, thanks for your input. Do you plan to support Sap Hana for maximum performance? Do you test with it? http://www.sap.com/developer/topics/sap-hana-express.html
Vlad Mihalcea January 10, 2017 at 10:19 AM
All HFT systems that I know (Tora Trading Services, Flow Traders, Open HFT) use Chronicle, memory mapped files without using any RDBMS. More, the best HFT systems operate below 100 microseconds already, to stay competitive. Hibernate is a tool meant for OLTP transactions, not OLAP, not HFT. Hibernate is suitable for web and enterprise applications, where, usually, a response time of 1 or 10 milliseconds is definitely fast.

Carsten Hammer January 10, 2017 at 9:26 AM
2018 the requirement for banks that join high speed trading is an accuracy of less than 100 microseconds away from utc.
http://qa-financial.com/news/testing/time-stamping-trades-mifid-ii/
This means hibernate needs to be much faster or allow other concepts..
Vlad Mihalcea April 27, 2016 at 2:26 PM
You're welcome. We've been running some benchmarks, and there were some optimizations being done for multi-tenancy, using a thread-local pooled optimizer. But for the pooled optimizer, if you increase the increment size, it takes around 150 microseconds to call the database sequence which is really fast.
Details
Assignee
UnassignedUnassignedReporter
Carsten HammerCarsten HammerComponents
Priority
Minor
Details
Details
Assignee
Reporter

I need maximal performance for bulk insert. Tests show that performance gain for stateless session can be high. But there are some strange things with sequencegenerator settings with allocationsize >1. Tests with named queries for bulk insert dont throw exceptions but do not write anything into the database.