I tested the performance problems that may be caused by the properties. When removing the display of Type, that is, type attributes, the performance has been greatly improved. Later tests also proved that the use of Type attributes caused the performance problems.
After thinking about it carefully, the reason for the low performance of Type should be that the reference to the Type property is the specific type information of the file, which is what we see in the resource browser. For example, the type of the TXT file is displayed as a "text document", but this type information is stored in the system and associated with the file extension. When using Type attribute in FSO, for each File object, FSO needs to retrieve the type name corresponding to the extension in the system according to the extension, which greatly reduces performance.
Therefore, when using FileSystemObject, if you can not use the Type attribute of the File or Folder object, try not to use it.
Hope this article will be helpful to you.