Re: Fwd: HSQL/MySQL query performance

The log shows the inserts are 3.5 times faster with HSQLDB.

As for your SELECT statements, you are selecting all the rows in the
table. The default CACHE ROWS and CACHE SIZE settings for HSQLDB allow
fewer rows, so each time you select, lots of rows are fetched from the
disk. 

Just increase the above settings until SELECT speed is what you want. I
think it should be faster than MySQL.

Fred 

On Wed, Dec 18, 2013, at 10:22, Viktor Ádám wrote:
> Hi!
> 
> We are migrating our application from MySQL to HSQLDB to have greater
> control over the database. Everything works great except that queries
> are slower than they were on MySQL.
> I've attached a simple test running the same CREATE/INSERT/SELECT
> statements on HSQL and MySQL and the produced output also. In the
> attached output MySQL queries are 4-5x times faster and on another
> development machine this ratio is about 8-10x.
> Can you give as a hint about what we're doing wrong? Are there any
> configuration parameters which could be tweaked?
> 
> Our test PC was:
> CPU: Intel Core i5-2400 @ 3.30GHz
> RAM: 4GB
> OS: Windows 7 Home Premium
> MySQL: 5.5.11
> 
> Thank you in advance!
> 
> Best regards,
> Viktor Ádám
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT 
> organizations don't have a clear picture of how application performance 
> affects their revenue. With AppDynamics, you get 100% visibility into
> your 
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> Email had 2 attachments:
> + dbperformance.txt
>   3k (text/plain)
> + DBPerformanceTester.java
>   8k (text/x-java)

------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk