[ http://issues.apache.org/jira/browse/DERBY-1713?page=comments#action_12428932 ] Ibrahim commented on DERBY-1713: --------------------------------
Thanks for these quick responses. It seems that I understood the problem. It is the unexpected behavior of OutOfMemory exception. So sorry because I was not careful for the SQL statement that generates the problem. It is: SELECT * FROM Contents ORDER BY Code, Seq Where Code & Seq are column names. So the problem with ORDER BY with two columns since it consumes the memory where if I ORDER BY one column the memory consumption is negligible. [I discovered this when I tried to simplify the program to send it] F.Y.I DDL (~92,000 lines): CREATE TABLE Contents(Code INTEGER, sheekhid INTEGER, Book VARCHAR(50), Seq INTEGER, Line LONG VARCHAR, Offset VARCHAR(10)) 'Line' column takes sometimes pages. Sorry for any inconvenience and thank you. > Memory do not return to the system after Shuting down derby 10.2.1.0, > following an out of memory event > ------------------------------------------------------------------------------------------------------ > > Key: DERBY-1713 > URL: http://issues.apache.org/jira/browse/DERBY-1713 > Project: Derby > Issue Type: Bug > Components: Performance > Affects Versions: 10.2.1.0 > Environment: Windows XP SP2 > JRE 1.6 beta2 > Reporter: Ibrahim > Priority: Critical > > I face a problem when querying large tables. I run the below SQL and it stuck > in this query and throws java heap exception OutOfMemory: > SELECT count(*) FROM <table> WHERE ..... > N.B. I'm using a database of more than 90,000 records (40 MB). I set the > maxHeap to 32 MB (all other settings have the default value, pageCache ... > etc ). > Then, I shutdown the database but the memory is not returned to the system > (and remain 32 MB [max threshold]). I tried to increase the maxHeap to 128 MB > in which it works and releases the memory, so I think the problem is when it > reaches the maxHeap then it seems to not respond to anything such as closing > the connection or shutting down the database. How can I get rid of this? > (because i cannot increase the maxHeap as the database increases, I want to > throw an exception and release the memory) > I'm using this to shutdown the DB: > try{DriverManager.getConnection("jdbc:derby:;shutdown=true");} > catch(SQLException ex){System.err.println("SQLException: " + > ex.getMessage());} > I'm using a memory Profiler for monitoring the memory usage. > Thanks in advanced. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
