Hi Thomas,
Please find attached a trivial patch for the features page to document
the units of the CACHE_SIZE setting.
KUTGW, cheers,
Jesse
--
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.
diff -Nuar svn/h2database-read-only/h2/src/docsrc/html/features.html svn-test/h2database-read-only/h2/src/docsrc/html/features.html
--- svn/h2database-read-only/h2/src/docsrc/html/features.html 2010-04-28 10:28:34.002005168 +0200
+++ svn-test/h2database-read-only/h2/src/docsrc/html/features.html 2010-04-28 10:42:27.614011102 +0200
@@ -1685,6 +1685,7 @@
<code>CACHE_SIZE</code>. This setting can be set in the database connection URL
(<code>jdbc:h2:~/test;CACHE_SIZE=131072</code>), or it can be changed at runtime using
<code>SET CACHE_SIZE size</code>.
+The size of the cache, as represented by <code>CACHE_SIZE</code> is measured in KB, with each KB being 1024 bytes.
This setting has no effect for in-memory databases.
</p><p>
Also included is an experimental second level soft reference cache. Rows in this cache are only garbage collected
diff -Nuar svn/h2database-read-only/h2/src/docsrc/text/_docs_en.utf8.txt svn-test/h2database-read-only/h2/src/docsrc/text/_docs_en.utf8.txt
--- svn/h2database-read-only/h2/src/docsrc/text/_docs_en.utf8.txt 2010-04-28 10:28:33.454006648 +0200
+++ svn-test/h2database-read-only/h2/src/docsrc/text/_docs_en.utf8.txt 2010-04-28 10:40:31.422005763 +0200
@@ -4640,7 +4640,7 @@
Cache Settings
@features_1598_p
- The database keeps most frequently used data in the main memory. The amount of memory used for caching can be changed using the setting <code>CACHE_SIZE</code>. This setting can be set in the database connection URL (<code>jdbc:h2:~/test;CACHE_SIZE=131072</code>), or it can be changed at runtime using <code>SET CACHE_SIZE size</code>. This setting has no effect for in-memory databases.
+ The database keeps most frequently used data in the main memory. The amount of memory used for caching can be changed using the setting <code>CACHE_SIZE</code>. This setting can be set in the database connection URL (<code>jdbc:h2:~/test;CACHE_SIZE=131072</code>), or it can be changed at runtime using <code>SET CACHE_SIZE size</code>. The size of the cache, as represented by <code>CACHE_SIZE</code> is measured in KB, with each KB being 1024 bytes. This setting has no effect for in-memory databases.
@features_1599_p
Also included is an experimental second level soft reference cache. Rows in this cache are only garbage collected on low memory. By default the second level cache is disabled. To enable it, use the prefix <code>SOFT_</code>. Example: <code>jdbc:h2:~/test;CACHE_TYPE=SOFT_LRU</code>. The cache might not actually improve performance. If you plan to use it, please run your own test cases first.
diff -Nuar svn/h2database-read-only/h2/src/docsrc/text/_docs_ja.utf8.txt svn-test/h2database-read-only/h2/src/docsrc/text/_docs_ja.utf8.txt
--- svn/h2database-read-only/h2/src/docsrc/text/_docs_ja.utf8.txt 2010-04-28 10:28:33.450005828 +0200
+++ svn-test/h2database-read-only/h2/src/docsrc/text/_docs_ja.utf8.txt 2010-04-28 10:41:12.290006230 +0200
@@ -4640,7 +4640,7 @@
ãã£ãã·ã¥ã®è¨å®
@features_1598_p
-# The database keeps most frequently used data in the main memory. The amount of memory used for caching can be changed using the setting <code>CACHE_SIZE</code>. This setting can be set in the database connection URL (<code>jdbc:h2:~/test;CACHE_SIZE=131072</code>), or it can be changed at runtime using <code>SET CACHE_SIZE size</code>. This setting has no effect for in-memory databases.
+# The database keeps most frequently used data in the main memory. The amount of memory used for caching can be changed using the setting <code>CACHE_SIZE</code>. This setting can be set in the database connection URL (<code>jdbc:h2:~/test;CACHE_SIZE=131072</code>), or it can be changed at runtime using <code>SET CACHE_SIZE size</code>. The size of the cache, as represented by <code>CACHE_SIZE</code> is measured in KB, with each KB being 1024 bytes. This setting has no effect for in-memory databases.
@features_1599_p
# Also included is an experimental second level soft reference cache. Rows in this cache are only garbage collected on low memory. By default the second level cache is disabled. To enable it, use the prefix <code>SOFT_</code>. Example: <code>jdbc:h2:~/test;CACHE_TYPE=SOFT_LRU</code>. The cache might not actually improve performance. If you plan to use it, please run your own test cases first.
diff -Nuar svn/h2database-read-only/h2/src/docsrc/textbase/_docs_en.properties svn-test/h2database-read-only/h2/src/docsrc/textbase/_docs_en.properties
--- svn/h2database-read-only/h2/src/docsrc/textbase/_docs_en.properties 2010-04-28 10:28:31.042004145 +0200
+++ svn-test/h2database-read-only/h2/src/docsrc/textbase/_docs_en.properties 2010-04-28 10:42:10.594007973 +0200
@@ -1545,7 +1545,7 @@
features_1595_p=\ Empty space in the database file re-used automatically. When closing the database, the database is automatically compacted for up to 1 second by default. To compact more, use the SQL statement SHUTDOWN COMPACT. However re-creating the database may further reduce the database size because this will re-build the indexes. Here is a sample function to do this\:
features_1596_p=\ See also the sample application <code>org.h2.samples.Compact</code>. The commands <code>SCRIPT / RUNSCRIPT</code> can be used as well to create a backup of a database and re-build the database from the script.
features_1597_h2=Cache Settings
-features_1598_p=\ The database keeps most frequently used data in the main memory. The amount of memory used for caching can be changed using the setting <code>CACHE_SIZE</code>. This setting can be set in the database connection URL (<code>jdbc\:h2\:~/test;CACHE_SIZE\=131072</code>), or it can be changed at runtime using <code>SET CACHE_SIZE size</code>. This setting has no effect for in-memory databases.
+features_1598_p=\ The database keeps most frequently used data in the main memory. The amount of memory used for caching can be changed using the setting <code>CACHE_SIZE</code>. This setting can be set in the database connection URL (<code>jdbc\:h2\:~/test;CACHE_SIZE\=131072</code>), or it can be changed at runtime using <code>SET CACHE_SIZE size</code>. The size of the cache, as represented by <code>CACHE_SIZE</code> is measured in KB, with each KB being 1024 bytes. This setting has no effect for in-memory databases.
features_1599_p=\ Also included is an experimental second level soft reference cache. Rows in this cache are only garbage collected on low memory. By default the second level cache is disabled. To enable it, use the prefix <code>SOFT_</code>. Example\: <code>jdbc\:h2\:~/test;CACHE_TYPE\=SOFT_LRU</code>. The cache might not actually improve performance. If you plan to use it, please run your own test cases first.
features_1600_p=\ To get information about page reads and writes, and the current caching algorithm in use, call <code>SELECT * FROM INFORMATION_SCHEMA.SETTINGS</code>. The number of pages read / written is listed.
fragments_1000_b=Search\:
