DZone Forums - View Single Post - PreparedStatement slow down the query execution?

glennji · 09-26-2008, 07:08 AM

Do multiple invocations of the query speed up?

A PreparedStatement is usually for a query that you're going to run a number of times -- it takes longer to "prepare", but then should be quicker to run.

Maybe time the prepareStatement() and the executeQuery() calls separately?

glennji Forum Leader Posts: 58 Thanks: 0 Thanked 1 Time in 1 Post Join Date: Feb 2008 Location: London	09-26-2008, 07:08 AM Do multiple invocations of the query speed up? A PreparedStatement is usually for a query that you're going to run a number of times -- it takes longer to "prepare", but then should be quicker to run. Maybe time the prepareStatement() and the executeQuery() calls separately?