Justin Deoliveira ha scritto: > Hi Andrea, > > You sure know your JDBC stuff!! :). I would love to see us use batched > prepared statements across the board, and in a more structured efficient > manner. Problem is as usual the jdbc beast is somewhat untamable.
Unfortunately, agreed :-( > Not sure how to proceed. Perhaps I will do some benchmarking to see how > significant the performance hit is on using the prepared statement. It really depends on the dbms. With Oracle the situation is as I explained, with old Postgres jdbc driver prepared statements were fake, in that the driver really built a full sql query and then sent it to the server, with no preparation at all (it was just a way to support ps API wise, while not really doing it on a practical level). Cheers Andrea ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
