To whom it may concern,

Is it possible to use the following sql synatx in Hibernate:

Insert table1(x, y) select table2.v1, table3.v2 from table2, table3 where table2.id = table3.id and table2.v4 = 1 and table3.v5=2

If yes, how can I use hibernate to generate a sql query like the above??

If not, what is the alternative in Hibernate that I can get almost the same performance as the above sql statement? I am dealing with more than 10 million rows insert. Thanks

Vivian Fonger

Hibernate is not suitable for mass inserts, updates and deletes, thats what JDBC and SQL are best for.

Some databases have utilities specifically for this type of insert. In SYBASE, it is bulk copy (BCP). The insert you described, with over a million rows, would run significantly faster if your database has this type of utility. SYBASE's BCP would increase your performance by a factor of 10 or so.