Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
questions about statement types and performace .
Joined: Jul 14, 2005
Jan 30, 2006 14:08:00
Which type of result set has best performace for a read only purpose ?
is it wise to use
ResultSet.TYPE_SCROLL_INSENSITIVE , ResultSet.CONCUR_READ_ONLY
i just want to retrive one column of one record (my query will return just one record)
Joined: May 26, 2003
Jan 30, 2006 19:49:00
ResultSet.TYPE_FORWARD_ONLY , ResultSet.CONCUR_READ_ONLY is best here. You don't need any scrolling capability or to update the data.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
Joined: Oct 14, 2005
Feb 01, 2006 09:23:00
That's true. Personally I only ever use forward-only, read-only result sets. However if your query is only returning one record, the choice is going to make almost no difference in practice.
It is sorta covered in the
JavaRanch Style Guide
subject: questions about statement types and performace .
core java optimization
Whats the difference in Statement and PreperedStatement ?
the property "hibernate.hbm2ddl.auto"
Files vs Arrays?
why would somebody do that??
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013