Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.x

Mapping documents:

<class name="example.ProfitLoss" table="pnl_vector" mutable="false"
select-before-update="false"
<composite-id name="key" class="example.ProfitLossKey">
<key-property name="assetId" column="asset_id" type="string"/>
<key-property name="date" column="date" type="int"/>
</composite-id>

<property name="value" column="value" type="double"/>
<property name="sysDate" column="sys_date" type="timestamp"/>
</class>

Code between sessionFactory.openSession() and session.close():
Transaction tx = session.beginTransaction();

session.save(profitLoss);
session.flush();
session.clear();

tx.commit();

Full stack trace of any exception that occurs:

Name and version of the database you are using:

Sybase

The generated SQL (show_sql=true):

insert into rbm_pnl_vector (value, sys_date, asset_id, date) values (?, ?, ?, ?)

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html



Everything works fine except it is very slow. Data volume is pretty high (easily exceed 50 million records). I don't have index on the table, and insertion slows down gradually. How do I improve the performance here?