[Deploying Sakai] Database vs. Filesystem

[Steve Swinsburg]

Hi Drew

Most argue that filesystem storage is better for performance.

However the filesystem structure is still not logical do you can't  
just navigate around the files Sakai creates. The files are just the  
binary bits of the files, the rest of the info about the file (title  
etc) is still in the database. There is also a path field which will  
point to the actual file on disk.

And files created in one site on one day might be in a very different  
location to one created the following day. But Sakai knows how to find  
them.

Try it out on a test instance and you will see the structure.

Cheers

~steve
[sent from my abacus]

On 21/06/2010, at 12:19, Drew Blessing <drew.blessing at esu16.org> wrote:

> I am considering storing content on the filesystem instead of in the  
> database.  Can anyone provide some pros and cons with doing so?  I  
> am imagining that management would be easier if the files were  
> logically stored on the filesystem.  I could conceivably navigate to  
> a user's workspace folder and see the files stored there.  These  
> possibilities would be very nice if/when we have a question as to  
> the content a user is storing.
>
> Thanks!
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org 
>  with a subject of "unsubscribe"