db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sunitha Kambhampati (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1679) Improve usage of file resources when sorting
Date Fri, 11 Aug 2006 20:12:13 GMT
Improve usage of file resources when sorting
--------------------------------------------

                 Key: DERBY-1679
                 URL: http://issues.apache.org/jira/browse/DERBY-1679
             Project: Derby
          Issue Type: Improvement
          Components: Store
    Affects Versions: 10.1.3.1, 10.1.3.0, 10.1.2.1, 10.1.1.0, 10.0.2.1, 10.0.2.0, 10.2.0.0
            Reporter: Sunitha Kambhampati
            Priority: Minor


Currently each sort merge run is put into a separate file.  Worst case,  the sot module can
use 512 open files per connection. 
This jira is to investigate how to improve file resources usage. Derby server should maintain
some control on open files.

Mike suggested that one solution could be to tie the open files into something like the open
file cache in the store, or maybe just store all the sort runs in a single file - i think
they are written sequentially so may not be hard to do using existing streamed file support
in the store.

Also see derby-1661.

-- 
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

        

Mime
View raw message