Search results for query: *

I doubt that this is the case because i checked this for a query with a String parameter and the datatype in the DB for the column is Varchar. Still the results were slow with String parameter.

I am comparing query execution time of a Prepared Statement when it is parameterized and when the parameters are embedded in the query.

I am not counting the time taken for preparing the PreparedStatement. The problem is there is difference in time for executing query when we parameterize the Prepared Statement and When we embed the parameters in the query of the Prepared Statement. Time difference is in running following line...

This is from a Java main class that i created for testing.

All, I am having a strange problem. All my queries are running 3 times slower when run using a prepared statement having parameters. Same query works 3 times faster when i embed those parameters in the query itself while making the prepared statement. I tested this with a simple JAVA jdbc...