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

[Jim Eng]

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