Does anyone have some handy metrics of the performance advantage of
prepared vs unprepared statements?  I'm considering the case of an
application which has to make multiple queries/inserts (30-100) per
application transaction and which is currenlty generating the sql by
building the strings on the fly then passing them to the JDBC.  Can I
expect significant (ie worth the recoding time) performance increases by
converting the statements into prepared statements?


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to