performance of bulk insert

Description

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.

Activity

Show:

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.

Rejected

Details

Assignee

Reporter

Components

Priority

Created September 24, 2015 at 11:26 PM
Updated January 10, 2017 at 11:14 AM
Resolved April 27, 2016 at 1:12 PM