|
|
|
Improvements to the file name hash list speed up file opens when many files are already opened. A file name hash list was introduced that is checked when a file is being opened to see if the file is already open. A file’s name is put into the hash list when the file is created or opened and is removed from the hash list when the file is physically closed.
With this strategy, optimization and execution of a SQL query that opened over 5000 files (multiple partitioned files) decreased from 10 seconds to 3 seconds on a specific test case.
