The SFTP server hits filesystem methods very frequently (e.g. four hits to readAttributes when selecting a file in Transmit), and so it'll be critical to add caching.
When implementing, it'll be important to ensure that the cache is invalidated properly. Going the route of checking the DB modification time will likely suffice, since it's quick enough.
This will end up related to the various access-related issues:
The SFTP server hits filesystem methods very frequently (e.g. four hits to
readAttributeswhen selecting a file in Transmit), and so it'll be critical to add caching.When implementing, it'll be important to ensure that the cache is invalidated properly. Going the route of checking the DB modification time will likely suffice, since it's quick enough.