[Building Sakai] Is anybody storing resource bodies...in MYSQLdatabase?

[Stephen Marquard]

Sorry that should be "large blobs"!

Large blogs doubtless are not a problem :-)
 
>>> "Stephen Marquard" <stephen.marquard at uct.ac.za> 05/08/09 8:45 PM >>> 
Our experiences with early versions of search that stored large blogs in the mysql db were not good. It introduced significant latency for queries.

I'd also like to know how one avoids the problem of reading the whole file into memory in order to get it into the db - is there a technique for doing this for Oracle that works for say 2G files being uploaded?

Regards
Stephen
 
>>> "will at serensoft.com" <will at serensoft.com> 05/08/09 8:40 PM >>> 
There's been some discussion lately about storing resource bodies
within the SQL database... But most who responded "yes" were using
Oracle, and reported little or no performance issues.

So:

Is anybody using MySQL for storing resource bodies? Any performance issues?

-- 
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"


_______________________________________________
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"