Problem in accessing records

[Javed420]

Hi.........

I am using Hsqldb 1.8.0.9 version. I have created text table with 5 columns in which I have inserted 1500000 records. but when i fire following query

Select * from table_name

it is giving "OutOfMemory error". Is there any special setting is required to be done before doing this.
waiting for replay................

[lucky001]

Hi Javed

Did you get any solution to this? I am getting same problem and no help is available anywhere. I think hsqldb is not good with handling TEXT tables.

Please let me know if you got any solution.

Waiting for your reply.

Sohail

Javed420 wrote:

Hi.........

I am using Hsqldb 1.8.0.9 version. I have created text table with 5 columns in which I have inserted 1500000 records. but when i fire following query

Select * from table_name

it is giving "OutOfMemory error". Is there any special setting is required to be done before doing this.
waiting for replay................

[fredt]

Result sets for select statements are held in memory, therefore very large
selects require very large Java memory allocations. You need to add a
condition
to limit the number of selected rows. Read the Guide and FAQ

Fred
----- Original Message -----
From: "lucky001" <soh_mah@...>
To: <hsqldb-user@...>
Sent: 11 July 2008 02:09
Subject: Re: [Hsqldb-user] Problem in accessing records



Hi Javed

Did you get any solution to this? I am getting same problem and no help is
available anywhere. I think hsqldb is not good with handling TEXT tables.

Please let me know if you got any solution.

Waiting for your reply.

Sohail




Javed420 wrote:

>
> Hi.........
>
> I am using Hsqldb 1.8.0.9 version. I have created text table with 5
> columns in which I have inserted 1500000 records. but when i fire
> following query
>
> Select * from table_name
>
> it is giving "OutOfMemory error". Is there any special setting is required
> to be done before doing this.
> waiting for replay................
>

--
View this message in context:
http://www.nabble.com/Problem-in-accessing-records-tp16273583p18394899.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.


-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user 


-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user