[Building Sakai] POLL: performance storing resource bodies in SQL database vs network-filesystem

[Luke Fernandez]

The perennial question; it keeps cropping up again and again.  I
recommend blob storage if you have the DB infrastructure to support
it.  Here are the reasons why:

1) Its easier to do backups because you don't have to do
synchronization management between your db and filestorage.

2) If you find after a while that you suffer a performance hit using
blobs you always have some out of the box scripts you can use to move
to file storage (you can do it the other way -- we did -- but we had
to write out own scripts).

Whatever you do, consult first with your DBAs.  I made the mistake of
taking my cues from what the Sakai mainstream orthodox recommendation
was (e.g. filestorage).  But our DBAs didn't like it so we switched
back to blobs a few months after we'd deployed live.

Luke



On Mon, May 11, 2009 at 11:01 PM, will at serensoft.com <will at serensoft.com> wrote:
> Hey folks --
>
> In your experience, which of the two is more responsive?
>
> A) storing resources as blobs in networked SQL database fields (where
> sql db is on a machine different from where tomcat is serving web
> pages)
>
> B) storing resources on networked file storage (where files are
> served/saved on a machine different from where tomcat is serving web
> pages)
>
> If the answer is "it depends" we'd love to hear the context. Your
> input and suggestions will be greatly appreciated.
>
> Thanks!
>
> --
> will trillich
> "Our only real economic security lies in our power to meet human
> needs." -- S.Covey, the 8th Habit
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>