We have a folder on a Windows Server 2003 R2 share. The folder is 3.17 GB and contains, 93,679 files (46,839 .txt, 46,832 .tif, 7 .jpg, 1 Thumbs.db). We have moved the folder to another Windows server, a Windows XP workstation and a ReadyNAS II Pro (which runs a Linux OS), but the problems persists.
The problems: 1) Opening this folder in Explorer (at the server or via a Windows XP client) takes much longer than opening other folders on the same share.
2) Opening any of the image files in the folder take an abnormally long time (10-20 seconds). The Windows viewer displays, "Generating preview..." while we wait.
The questions: 1) What is the maximum number of files that should be storing in a single folder? We understand the theoretical limits are very high, but at what point is performance affected?
2) Does the fact that we are storing images in the folder have an impact on the number of files that can be stored in a single folder before performance is impacted?
Links to sources are very much appreciated.