Load List Values for Improved Efficiency
An anonymous reader writes "Reduce the number of database hits and improve your Web application's efficiency when you load common shared list values only once. In this code-filled article, learn to load the values for drop-down lists when your Web application starts and then to share these loaded list values among all the users of your application."
"And people, I can't stress this enough. Put your garbage in the garbage can."
"Garbage in the garbage can. Hmm. Makes sense."
I'm a big tall mofo.
Is this April First?
Wow, next an article about using "for" loops? The benefits of "bubble sort"? "Binary trees"?
D.O.U.O.S.V.A.V.V.M.
...this "Lead Developer" at IBM will discover the wonderful performance benefits of pooling database connections, rather than open a new connection every single fricking time he hits the database. No wonder he saw a massive performance increase when he learned how to cache the lookup values.
And what's up with the "obj_" prefixes in some of the code listings? Newsflash: Java is an object-oriented programming language, and most competent Java programmers can figure out that a variable called resultSet probably isn't a primitive. You don't need to waste another 4 characters pointing out that fact.
Looks like you had an SQL Statement timeout there.