Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

problem with update using preparedstatement  RSS feed

 
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
Sheriff
Posts: 37222
519
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?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!