JDBC batch mode support in SQL Anywhere 11.0.1: Better late than never!

In my opinion, SQL Anyhwere is the best RDBMS I can think of. I can remember when we started distributing it in Germany back in the early 1990ies, as one of the first early adopters in this country. Since then, we provided it to hundreds of enterprises, from single-person laptop-only ones to large ones spanning replicated installations crossing country borders. So call me biased in that point, but never did I wish to move on to a differed one, even now after decades. It's like a Volkswagen. It runs and runs and runs, and needs virtually no administration. Actually I love it. But what I do not love is its performance. There are some things I wish could work just faster. But as it is impossible to get optimum performance with a zero-administration system obviously, one has to take care to do performance-friendly coding. There is much room in the JDBC API to squander performance - or to win some. One thing that will give a performance boost in some situations is batching processing: Adding several commands together into one large packet, getting all of them processed in one single step, will not only keep the LAN latency's influence on the transaction's execution time low by reducing the amount of LAN roundtrips (and such offers others the possibility to use the LAN in the freed time slices), it also speeds up own transaction speed ...

Date: July, 03 2010
Url: http://www.java.net/blog/mkarg/archive/2010/07/03/jdbc-batch-mode-support-sql-anywhere-1101-better-late-never

Others News