There are no limitations of number of files in a flat folder. There is a limitation in our tool MXFS for listing those files in a single directory for the first time in that it takes a little while to load, after that the speed is good. Alternatively is the MAM knows the path to the DPX file required, or the GUID via the API, then there is no limitation.