[Building Sakai] Is anybody storing resource bodies in database?

[Joshua Swink]

The total count is 151645.

Thanks for the heads up. I'll look into BINARY_ENTITY serialization.
Anything we can do to improve performance is welcome, especially with
hardware budgets so tight these days.

Josh

On Thu, Apr 23, 2009 at 1:52 PM, Jim Eng <jimeng at umich.edu> wrote:
> Hi Josh,
>
> It would be interesting to know how many rows are in the table in total.
>  Can you ask that also:
>
> select count(*) from content_resource;
>
> You might want to do the conversion to BINARY_ENTITY serialization.  There's
> no hurry for you to do that while the tables are small, but it speeds things
> up in several ways, which is especially important for people with larger
> tables.
>
> There's also no hurry for you to convert to filesystem storage of resource
> bodies unless you want to.  As Seth mentioned, you will need a new version
> of CHS that is not yet ready to make that conversion.
>
> Jim
>
>
> On Apr 23, 2009, at 4:40 PM, Joshua Swink wrote:
>
>> Yep, the result is 87535.
>>
>> Josh
>>
>> On Thu, Apr 23, 2009 at 12:49 PM, Seth Theriault <slt at columbia.edu> wrote:
>>>
>>> Joshua Swink wrote:
>>>
>>>> I don't know whether we are using XML serialization. We've been
>>>> running this instance of Sakai since before 2.5.
>>>
>>> If you have any content created in 2.5 and beyond, you are affected.
>>>
>>> I have used this SQL -- on Oracle so YMMV -- to check for problems:
>>>
>>> select count(*) from content_resource where XML is not NULL;
>>>
>>> Any result greater than 0 means you have some content using the
>>> older XML method.
>>>
>>> Seth
>>>
>>
>>
>
>