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.
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 Derby.
These tips might solve your particular performance problem. Be sure to
visit the Support section of Derby's Web site for up-to-date performance
tips and tricks.