derby does not have tablespaces. All tables are in one directory and
thus must be on one logical disk. One could use the OS to spread that
disk across multiple disks. One can also place the derby recovery log
on a separate device.
Derby control over the buffer pool is by setting maximum number of
pages. It defaults to 1000 pages. And the pages can range from 4k to
32k. To set page size see setting the page cache size:
http://db.apache.org/derby/docs/10.3/tuning/ctunperf54492.html
Suman N wrote:
Hi,
Is it possible to create a BUFFERPOOL and TABLESPACE in Derby? If it is
possible how should I do that?
Thanks,
Suman
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else
is unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted to be taken in reliance
on it, is prohibited and may be unlawful. If you are not the intended
addressee please contact the sender and dispose of this e-mail. Thank you.
