Ivan Zhakov wrote:
> On Fri, Jan 9, 2009 at 12:25 AM, Hyrum K. Wright <hyrum_at_hyrumwright.org> wrote:
>> Author: hwright
>> Date: Thu Jan 8 13:25:09 2009
>> New Revision: 35086
>>
>> Log:
>> Followup to r35085: Remove another properties-related table in favor of BLOB
>> column in yet another table.
> Hi Hyrum,
>
> What is the benefit of storing properties in BLOB column instead of
> properties table? I assume you know that in working copy code we often
> need to answer question "Does this file has property svn:keywords" and
> similar stuff. I think that storing properties in not serialized way
> will help to answer such question easier and faster.
There are a couple of issues at play here. First, storing the properties in a
separate table requires performing a join and read from that table. In the vast
majority of cases, we envision reading properties at the same time we're reading
the other data in the node, so it makes sense to store those properties in the
same place as the rest of the node data. We plan on serializing the BLOB using
the existing skels format, which should be pretty negligible overall.
-Hyrum
------------------------------------------------------
http://subversion.tigris.org/ds/viewMessage.do?dsForumId=462&dsMessageId=1012506
Received on 2009-01-09 00:06:46 CET