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

List:       hsqldb-developers
Subject:    Re: [Hsqldb-developers] Load Data into HSQLDB
From:       "Fred Toussi" <fredt () users ! sourceforge ! net>
Date:       2011-04-27 8:50:47
Message-ID: 1303894247.32256.1445578681 () webmail ! messagingengine ! com
[Download RAW message or body]

Please use CREATE CACHED TABLE, or for an existing table, SET TABLE name
TYPE CACHED.

See the guide on different table types.

Please post any future questions to the hsqldb-user mailing list.

Fred

On Tue, 26 Apr 2011 17:09 -0700, "kushal bansal"
<kushalbansal@yahoo.com> wrote:
> Hi,
> 
> I am newbie to HSQLDB. I am using HSQLDB 2.1 in file mode. I used the
> command to launch the UI
> 
> java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing
> 
> Then I provided URL as : jdbc:hsqldb:file:E:\test\testdb. and hit on
> enter
> I created a sample cached table to load records into it. To load records
> I selected 'Open script' from UI and tried to give path of a .sql file
> with 100k 'Insert into' statements. I see that when I try to load lesser
> number of records like 20k I succeed. But when I try to insert 100K+
> records I am not able to do that. 
> 
> I even tried changing the .script file with the following
> 
> SET FILES CACHE SIZE 1000000
> SET FILES CACHE ROWS 1000000
> SET FILES SCALE 16
> 
> still no success. Kindly help. Thanks in advance.
> 
> 
> 
> ------------------------------------------------------------------------------
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network 
> management toolset available today.  Delivers lowest initial 
> acquisition cost and overall TCO of any competing solution.
> http://p.sf.net/sfu/whatsupgold-sd
> _______________________________________________
> hsqldb-developers mailing list
> hsqldb-developers@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
> 

------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
[prev in list] [next in list] [prev in thread] [next in thread]