db Servlets: Performance Considerations

• Opening and closing the database

  Open at init method and configure your Web server to preload the servlet when the system is started
  

• Closing result sets and SQL statements

  If you don’t close them, your JDBC won’t know they’re available and could open the same database needlessly multiple times
  

• Get the most out of each SQL call

  Combine more than one file (data set) into same select
  

• Some data is better off on the web server

• Use out.flush() to send partial results back to browser

Previous slide

Next slide

Back to first slide

View graphic version

Send email to Interex or to the Webmaster
©Copyright 1999 Interex. All rights reserved.