Richard Whitely

Greenhorn
+ Follow
since Feb 08, 2002
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Richard Whitely

It sounds like u are preparing the statment every time u use it, prepare it once then use it many times to see the performance improvment over a statment.
In the Programming Style Guide area of JavaRanch it states:

"Never use a do...while"
I belive that there are certain situations where a do...while is good e.g. examining a resultset (which isn't scrollable).

Example with do...while
-----------------------

Example without do...while
--------------------------

Any opinions are welcome... especially any equaly attractive sollutions which dont ude do...while.