Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes problem with update using preparedstatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "problem with update using preparedstatement" Watch "problem with update using preparedstatement" New topic

problem with update using preparedstatement

Manasa Tripathy

Joined: Nov 07, 2004
Posts: 1
I am using preparedstatement to fire insert / update statements.
the update query is taking a lot of time(min 150 ms) where as the insert query takes 0-10 ms .

i'm using mssql driver with sql2000.

if i use Statement instead of preparedstatement it just takes 0-10 ms.

even after firing 1000 querries the time taken by preparedstatement to execute an individual query remains same -then wht's the advantage i am getting from prepared statement???

what might be the problem???

[ November 07, 2004: Message edited by: Manasa Tripathy ]
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32644

Can you show the prepared statement's SQL?

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: problem with update using preparedstatement
It's not a secret anymore!