Application and database design issues

Things that you can do to improve the performance of Derby applications fall into three categories. In order of importance, these categories are:

1. Avoiding table scans of large tables
2. Avoiding compiling SQL statements
3. Shielding users from Derby class-loading events