> Cayenne adapters for Oracle, Derby, FrontBase, Postgres and SQLServer
> use JDBC-level batching that sometimes speeds things up
> significantly. SQLTemplate doesn't use JDBC batching. There are other
> possible reasons too, such as pk caching.
Thanks for the hint. How can I make sure that
What I found was that in Insert operations, it is best to use
Cayenne data objects (as opposed to raw SQL queries)
Cayenne adapters for Oracle, Derby, FrontBase, Postgres and SQLServer
use JDBC-level batching that sometimes speeds things up
significantly. SQLTemplate doesn't use JDBC batchi
