• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem with update using preparedstatement

 
Manasa Tripathy
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
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???

Regards
Manasa
[ November 07, 2004: Message edited by: Manasa Tripathy ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34073
335
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Manasa,
Can you show the prepared statement's SQL?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic