From: kushal b. <kus...@ya...> - 2011-04-27 00:09:31
|
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. |
From: Fred T. <fr...@us...> - 2011-04-27 08:50:57
|
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 > |