Volunteers are needed to run tests on different operating systems with the
new CVS code.

I have just committed the changes since RC2 to CVS. One of these changes is
a fix for a recently reported bug with large .data files using java.nio.

When the jar is compiled and run with JDK 1.4, the default method of access
to the .data file is via a mapped memory buffer. This results in a very
significant speed increase when the .data file is larger than a few
megabytes.

Mapped memory file sizes are limited by the amount of memory that the OS can
allocate. The Java implementation has several undefined, OS-dependent
features.

When the .data file grows to a size that cannot be mapped to memory by the
OS, the new code in HSQLDB stops using java.nio and accesses the .data file
as a random access file. We need more tests to verify the new code is
working correctly.

The org.hsqldb.test.TestCacheSize class should be used for the tests. In the
code, a variable named 'bigrows' specifies the number of rows to be inserted
in each of two large tables. The main method of this class should be
executed with bigrows set at 1,000,000 - 1,500,000 - 2,000,000 - 3,000,000 -
4,000,000. Depending on the amount of memory, tests with up to 1 - 2M rows
should finish in a few hours due to use of a memory mapped file, but beyond
that, it will probably take over 24 hours to complete each test. CPU speed
has less effect on these tests than disk access speed. Up to 6GB disk space
is required.

The test creates a database in a directory, The directory listing at the end
of the test is of interest as it indicates the file sizes. The console
output indicates which errors occured during the test. Please save the
listing and the output to a file then add the computer and OS details to the
file and upload to the Bug Tracker. (a few unique index violation errors may
be reported in the initial stage but these are not internal engine errors
and can be ignored).

You should first run a test with small (50,000) bigrows to make sure things
are working. Delete the database files before running the next test.

Fred Toussi



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers

Reply via email to