Re: [Hsqldb-developers] Load Data into HSQLDB

[Fred T. <fr...@us...>]

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"
<kus...@ya...> 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
> hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
>