This content has been marked as final. Show 4 replies
The mentioned parameter is supposed to be set via sql command:1 person found this helpful
Stmt.execute( "SET PROPERTY \"hsqldb.cache_file_scale\" 8" ); Stmt.execute( "CHECKPOINT" );
Thanks! But where would I run the sql statement. When anyone launches the application it creates the database files in their user directory. How would I connect to the database after that to execute the statement?
I see the create table statements in the files I have pulled into NetBeans in both the source folder and the distribution folder. Could I add the statement there before the table is created in the jar file in the distribution folder and then re-compile it for distribution? OR would I need to add it to the file in source directory and recompile those to create a new distribution?
From searching on the itnernet it appeared that the parameter hsqldb.cache_file_scale needed to be increased & 8 was a suggested value.But it already is 8.
If you want to increase it further, obviously you have to change the line of code that generates the line above.
So what's your question?
Sorry, it is cache_file_scale = 1 is the value that I believe needs to be changed to 8.