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

[Kyong Kim]

This problem might be MySQL specific as well.
At one of the MySQL tutorials I attended,  the issue of BLOB performance
came up. The only way BLOB column can be made usable in production is if
the column can be extracted to a separate table from the rest of the table
according to a MySQL engineer. This experience was shared by a lot of
DBA's dealing with performance issues with BLOB columns of various sizes.

>From my experience, we encountered a serious performance problem early on.
Ideally, you want to maintain data integrity but when it comes to
performance and scaling, best practices sometimes go out the window.

Kyong

> 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-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to
> sakai-user-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>


Inst. Web Programmer
CMDBA 5.0