File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
problem with update using preparedstatement
Joined: Nov 07, 2004
Nov 07, 2004 01:41:00
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 ]
author & internet detective
Joined: May 26, 2003
Nov 07, 2004 12:04:00
Can you show the prepared statement's SQL?
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: problem with update using preparedstatement
preparedstatement advantage (jdbc experts)
problem in insering data in msaccess thru jdbc
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015