>It has been done in this manner. Question: Will using FSIZE cause an increase in network traffic?
Calvin,
I doubt that FSIZE() would cause any noticable difference. If I were to hazard a guess, it's simply making an API call to GetFileSize() and that requires getting a file handle, making the call, and closing the handle. It's probably less than using something like ADIR(), which returns significantly more data.
Using the calculation would probably result in less network traffic because it's based on functions that utilitize information in the header of the table and, therefore, wouldn't require additional trips across the wire. Whether or not the difference is of any significance would depend on external factors. My hunch is that it probably wouldn't be significant, but only you can determine that for certain.
George
Ubi caritas et amor, deus ibi est