posted 19 years ago
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 ]