phoenix icon indicating copy to clipboard operation
phoenix copied to clipboard

use PreparedStatement

Open bd2019us opened this issue 6 years ago • 1 comments
trafficstars

Hello, Is it a good way to use "PreparedStatement" instead of "createStatement" in order to improve performance? "PreparedStatement" is used to execute dynamic or parameterized SQL queries. It is helpful if we are executing a particular SQL query multiple times ( such as in a loop in this case) since "PreparedStatement" can be precompiled and the query is created only once.

bd2019us avatar Feb 26 '19 20:02 bd2019us

Hi @swaroopak, sorry for the late reply. I just submit a patch to JIRA for Hadoop QA. Please check it.

lx0704 avatar Jul 25 '19 03:07 lx0704