Prepared statements in portable applications  If most dynamic statements are executed very few times

Chapter 4: Performance and Tuning

Prepared statements with jConnect extensions

If you are not concerned about portability across drivers, you can write code that uses SybConnection.prepareStatement( ) to specify whether a PreparedStatement object contains precompiled or uncompiled statements. In this case, how you code prepared statements is likely to depend on whether most of the dynamic statements in an application are likely to be executed many times or only a few times during a session.





Copyright © 2003. Sybase Inc. All rights reserved. If most dynamic statements are executed very few times

View this book as PDF