Hi,
We have an HSQL-server mode installation (2.2.8) and a Tomcat-hosted application connecting to it. The application uses Liquibase to create the tables and version changes. All works fine.
Trouble is we're finding performance quite slow having now begun more serious testing. The VM instance it's running in has 4G of memory allocated yet hsqldb appears to have the following when checking top:
1061 hsqldb 20 0 3659m 2.2g 4992 S 0 57.6 6843:21 java The server.properties file is as follows: server.database.0 file:data/mjls
server.dbname.0 mjls server.silent true server.trace false server.port 9001 server.no_system_exit true The data directory holds: -rw-r--r-- 1 hsqldb hsqldb 16 Jul 18 17:18 mjls.lck -rw-rw-r-- 1 hsqldb hsqldb 11M Jun 20 10:29 mjls.lobs -rw-rw-r-- 1 hsqldb hsqldb 7.8M Jul 18 17:18 mjls.log
-rw-rw-r-- 1 hsqldb hsqldb 85 Jul 18 16:59 mjls.properties -rw-rw-r-- 1 hsqldb hsqldb 1.2G Jul 18 16:59 mjls.script We have today used Liquibase to add indexes to the fields of the main entities used in the WHERE clauses but without much wall-clock difference which I find somewhat surprising.
So what's next in our investigations? Any good tool to help us understand our position or particularly obvious configuration tweaks we've failed to notice/apply? Thanks,
James ------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk _______________________________________________ Hsqldb-user mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
The listing shows a huge .script file which contains data for memory tables. Therefore you probably need a larger memory allocation or alternatively, storing some data in cached tables.
See the Guide.
Fred
On Thu, Jul 18, 2013, at 17:23, James Green wrote:
------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk _______________________________________________ Hsqldb-user mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
Free forum by Nabble | Edit this page |