For a client database, I created a simple feature that displays the current database size using Get (FileSize).  This seemed to work fine locally, but when I hosted the database on their server I'm noticing several discrepancies.

 

1.  The actual File Size (and Date Modified, etc.) do not update in the Windows Explorer window on the server when the file is being modified by clients.  Can someone tell me what prompts the update here?  It's not when the database is closed/reopened, because the list of hosted files show recent updates and the files have not been closed recently.

 

2.  For some clients and in some instances, the Get (FileSize) calculation will return:

a ). a new value (eg. larger file size) when a client increases the file size by inserting a file into a container

b ). no change to the value when a client deletes the file from the container

c ). no change for either inserting/importing a file OR deleting the file

 

Again, in the instances mentioned above, there is NO CHANGE to the file size or date modified info in Windows.

 

Any ideas?  Thanks.

FMS caches a lot of data and delays writing to disk to improve performance. This would make calculating the file size quite difficult while the file is hosted.

 

If the file is hosted in FMS then you should NOT be accessing it directly, not even to calculate the file size or get other metadata.