Slashdot Mirror
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.
It's because of all the Adblock users out there that we get ads as stories now. The summary even reads like one. Or it's just a slow news day.
It all depends on how tight your tin foil hat is.
Seriously, I've you're into servlets and you haven't been caching non dynamic data, shame on you.
By same token, if you're on of those twits who caches five years of data warehouse information in the application layer, there's a special place in programmer hell for you...
...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.
Thank you so much for telling me this. I would have been completely stuck if you hadn't, I had missed the java headers right at the top of the first bit of code and thought it was ZX80 assembler.
Thanks for the hot tip... I'm really anxious to see how the world changes now that the concept of the cache has finally been brought to light. Behold, sarcasm, I've invented sarcasm! Wow, maybe we should create a /. article for me?
Is that "Lead" the element Pb, or "Lead" as in, in charge. Seems like his code is as heavy as the former.
Anthropic principle: We see the universe the way it is because if it were different we would not be here to see it.