in the pictures table, whats the difference between filesize and total_filesize ????
filesize is the size of the fullsize pic you uploaded, total_filesize is the sum of fullsize, intermediate and thumbnail (which is used to calculate quota restrictions).
HTH
Joachim