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
