Comment: Limits onUser Uploads

" NickR: In both situations a simple SQL UPDATE would do the job for all members at once...

"

I would of thought it not a simple update.

User a has used 4 megs of 5

User b has used 3 megs of 5

Using the boundary is it simple as adding X to 5 in one place.

User a has 1 meg left User b has 2 meg left

Using the bucket you would have to modify each db record by adding X which is a bigger overhead...

Correct me if I am mistaken though.

As this is not likely to be a often used feature (changing the upload limit), the overhead probably does not matter.

Which would be better to implement from a downloading point of view (eg changing the db record as files are downloaded)?

Finally...

One thing to consider, how do you count the same file being downloaded multiple times... does it add to your quota, or do you ignore, as if the download fails or you click the link twice you could be unfairly penalised ?

Nick