+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / Libraries and storage (database tables)

Libraries and storage (database tables)

4 posts, 1 answered
  1. Lucas
    Lucas avatar
    65 posts
    Registered:
    22 Mar 2010
    13 Aug 2010
    Link to this post
    Hello,

    I'm wondering how content is stored physically in the database: I am importing a lot of documents, and I discovered that there were 2 tables that seem to be storing the file content :
    - sf_CmsBinaryContent (which I expected)
    - sf_VrsBinData

    Is there a way to have the content only stored once? I imagine sf_VrsBinData is used for rollbacks? Is it possible to disable this functionality (either temporarily -for my import- or permanently ?

    I can't really have 5Gb of unused data sitting in the db ;)

    Thanks a lot!

    -- Lucas
  2. Bruno Michels
    Bruno Michels avatar
    125 posts
    Registered:
    16 Apr 2010
    13 Aug 2010
    Link to this post
    Yes, you can disable it, see this article.

    You can also setup a trigger to keep only a limited number of versions, as I've posted here.

    You can also store the files on folders by modifying the web.config

    <libraries defaultGenericProvider="Libraries"
      streamingProviderName="Files"
      streamingIsEnabled="True">
    Answered
  3. Lucas
    Lucas avatar
    65 posts
    Registered:
    22 Mar 2010
    13 Aug 2010
    Link to this post
    Thanks a lot Bruno!

    For now, I'm gonna remove the items that are added automatically by my process from the sf_VrsBinData table and see how Sitefinity reacts :)

    Thanks!
  4. Lucas
    Lucas avatar
    65 posts
    Registered:
    22 Mar 2010
    13 Aug 2010
    Link to this post
    Weirdly enough, it seems the provider has already disabled versioning:

    <add name="Libraries" urlRewriteFormat="~/{Provider}/{LibraryName}/[Name].sflb.ashx" urlDateTimeFormat="yy-MM-dd" urlWhitespaceChar="_" visible="False" defaultMetaField="Name" applicationName="/Libraries" allowVersioning="False" allowLocalization="False" localizationProviderName="" allowWorkflow="False" securityProviderName="" versioningProviderName="" connectionStringName="GenericContentConnection" type="Telerik.Libraries.Data.DefaultProvider, Telerik.Libraries.Data" tagEditorTemplate="~/Sitefinity/Admin/ControlTemplates/Libraries/BatchTagsEditor.ascx"/>

    I'll just delete the records, then
Register for webinar
4 posts, 1 answered