Since every file is on the server, I'm debating the need for a database entry corresponding to each file. The following information needs to be kept on each file/directory for every user:
- Whether it was deleted or not (since deletes need to be synced to other clients)
- The timestamp of when every file was last modified (so I know whether the file needs updating by the client or not).
I could keep both of those pieces of information in files (e.g. .deleted file and .modified file in every user's directory containing file paths + timestamps in the latter) or in the database.
However, I also have to fit under my 80mb memory constraint. Between file storage and database storage, which would be more memory-efficient for this purpose?
May 30 '11 at 14:08