Application and database design issues

Things that you can do to improve the performance of Derby applications fall into three categories.

• Avoiding table scans of large tables
  
• Avoiding compiling SQL statements
  
• Shielding users from Derby class-loading events