12-02-2012, 02:54 AM
(12-01-2012, 05:46 PM)axel76 Wrote: You should create a new column ( size ) in the tblDocuments,
or create a new table ( size_documents ) correlated to id documents.
Add new column ( quota ) in tblFolders.
When user go to upload page, SUM the total size docs and match with folder quota.
This will work with all platforms, will be very fast, and low CPU usage.
IMHO, this is too simple. If there is folder with a quota and that quota is exceeded I could simply create a new subfolder and upload more documents. If I want to prevent that, I have to check for any quota of any parent folder.
Uwe