Forums Register Login

When not to use PreparedStatement

+Pie Number of slices to send: Send
Hi Can anyone clarify the below quote from this

Sometimes prepared statements can actually be slower than regular queries. The reason for this is that there are two round-trips to the server, which can slow down simple queries that are only executed a single time.



At what point of time this two round-trips happens?

thanks
Raj
[ December 18, 2008: Message edited by: raj malhotra ]
+Pie Number of slices to send: Send
I'd ignore the comment. In practice the compilation time for a one-off statement is unlikely to impact your application, where compiling the same statement millions of times will.
+Pie Number of slices to send: Send
thanks David
Ruth Stout was famous for gardening naked. Just like this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1121 times.
Similar Threads
How to compare two queries based on efficiency
Alternative to JavaScript?
hibernate cache
Bulk Data Processing
running java app as a batch job
More...

All times above are in ranch (not your local) time.
The current ranch time is
Apr 16, 2024 00:23:58.