[prev in list] [next in list] [prev in thread] [next in thread] 

List:       hsqldb-user
Subject:    Re: [Hsqldb-user] File size Vs insert rate
From:       "Fred Toussi" <fredt () users ! sourceforge ! net>
Date:       2011-06-01 9:52:44
Message-ID: 1306921964.6497.1458281797 () webmail ! messagingengine ! com
[Download RAW message or body]


Even within the 1GB limit used for nio, larger files require more disk
seeks. It is down to the JVM's implementation of nio, which seems to
save data to the disk during operation.

There are also other elements, the .backup file and the .log file.
During updates data is written to both these files, and there are more
disk seeks with larger files. For example, you can turn the data logging
off during mass inserts to improve performance.

Please use the latest 2.2.2, which fixes a few issues discovered since
the release of 2.1.0.

Fred

On Wed, 01 Jun 2011 10:46 +0200, "Andrea Manca" <manca@link.it> wrote:
> 
> I'm checking the system's behavior as the number of rows inserted grows 
> (using HyperSQL 2.1.0).
> Because of these increases, also increases the size of the file .data 
> (in the case of cached tables), I set
> 
> "SET FILES NIO SIZE 1024"
> 
> I monitored the size of the file .data and put it in relation to the 
> rate with which my application inserts rows in the database (the 
> application performs an INSERT for each request)
> We expect that on reaching the size of 1GB, the rate of entry decreased 
> significantly, and that is what happens.
> 
> I wondered however, why as long as the size of the file .data remains 
> below of the threshold of 1GB, the rate decreases with increasing of the 
> input file size.
> Is it possible am i missing something ?
> 
> 
> -- 
> Andrea Manca
> Link.it s.r.l - www.link.it
> manca@link.it
> 
> 
> ------------------------------------------------------------------------------
> Simplify data backup and recovery for your virtual environment with
> vRanger. 
> Installation's a snap, and flexible recovery options mean your data is
> safe,
> secure and there when you need it. Data protection magic?
> Nope - It's vRanger. Get your free trial download today. 
> http://p.sf.net/sfu/quest-sfdev2dev
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> 

------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger. 
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Data protection magic?
Nope - It's vRanger. Get your free trial download today. 
http://p.sf.net/sfu/quest-sfdev2dev
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
[prev in list] [next in list] [prev in thread] [next in thread]