- Use prepared statements with substitution parameters to save
on costly compilation time. Prepared statements using substitution parameters
significantly improves performance in applications using standard statements.
- Create indexes, and make sure they are being used. Indexes
speed up queries dramatically if the table is much larger than the number
of rows retrieved.
- Increase the size of the data page cache and prime
all the caches.
- Tune the size of database pages. Using
large database pages has provided a performance improvement of up to 50%. There are also other storage parameters worth tweaking. If
you use large database pages, increase the amount of memory available to .
- Avoid expensive queries.
- Use the appropriate getXXX and setXXX methods for the type.
- Tune database booting/class loading. System
startup time can be improved by reducing the number of databases in the system
directory.
- Avoid inserts in autocommit mode if possible. Speed
up insert performance.
These tips might solve your particular performance problem. Be sure to
visit the Support section of 's Web site for up-to-date performance
tips and tricks.