Tune the size of database pages

Tune the size of database pages Tune the size of database pages. Using large database pages has provided a performance improvement of up to 50%. If you use large database pages, increase the amount of memory available to . derby.storage.pageSize Page sizeperformance implications of

In most situations, use the default page size of 4K (the size operating systems use). Increase the page size in any of these cases:

You are storing large objects.
You have very large tables (over 10,000 rows).
For very large tables, large pages reduce the number of I/Os required.
For read-only applications, use a large page size (for example, 32K) with a pageReservedSpace of 0.

You might need to experiment with page size to find out what works best for your application and database.