A
Andrew Meador
Flightless Bird
I have an Access databse that references image files in a folder.
There are currently 2700 files in this folder and will reach a total
of appx 10000 files when data collection is done. The one of the
database screens allows the user to double-click the image which then
executes an external program with the path and name of the file to
open. So the external app gets the exact path and file name to open,
but the open process takes about 20 seconds to occure. I can go strait
to the folder where the files are a double click the file and the
application still takes and equally long time to open the file.
However, if in a folder with only a small number of files, the app
opens the image almost instantly. So there appears to be a preformance
issue with opening even an explicit file in a folder with a large
number of files. I know I could split the files over multiple folder
to improve performance, but this require a fair bit of re-coding of
the database and re-trainined of the users, etc... Is there any
performance options beides the multiple folder idea? Why does the
number of files in the folder hind the opening process so badly when
specific file is targeted?
Thanks in advance!
Andrew
There are currently 2700 files in this folder and will reach a total
of appx 10000 files when data collection is done. The one of the
database screens allows the user to double-click the image which then
executes an external program with the path and name of the file to
open. So the external app gets the exact path and file name to open,
but the open process takes about 20 seconds to occure. I can go strait
to the folder where the files are a double click the file and the
application still takes and equally long time to open the file.
However, if in a folder with only a small number of files, the app
opens the image almost instantly. So there appears to be a preformance
issue with opening even an explicit file in a folder with a large
number of files. I know I could split the files over multiple folder
to improve performance, but this require a fair bit of re-coding of
the database and re-trainined of the users, etc... Is there any
performance options beides the multiple folder idea? Why does the
number of files in the folder hind the opening process so badly when
specific file is targeted?
Thanks in advance!
Andrew