I set
PAGE_SIZE=8192
CACHE_SIZE=131056
WRITE_DELAY=10000
But did not see a considerable speedup with my database.
I do not use CLOBs or BLOBs so that might have been one reason.
Also I did not make any precise measurements but just wanted to share my
experience.
There might have been some speedup but I would say it was definately
less than 100%
I would have expected that setting the write delay that long would have
had a big impact.
The point being that what is most important would be to have clear
measurements on
what affects what. And it might be difficult to say what is the most
optimal page_size
or how much does the write delay affect performance in different usage
scenarios.
What I noticed though was that documentation says that PAGE_SIZE can
only be set
when creating the database. Further there is no way to see what the
actual PAGE_SIZE is.
At least it was not listed in the SETTINGS table.
In order to test this kind of feature it would be nice if one could
change it whenever needed
and more importantly somehow verify what it actually is.
- rami
On 16.6.2011 22:09, Nitin wrote:
Hi Thomas,
Is this (detect and set the best page size) coming in next release ?
may be as experiment or to gather feedback for more fine tuning ?
Regards,
Nitin
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
