More in this section

Forums / Developing with Sitefinity / Generic Content for everything?

Generic Content for everything?

2 posts, 1 answered
  1. Jeff Vail
    Jeff Vail avatar
    14 posts
    Registered:
    06 Dec 2003
    20 Jul 2010
    Link to this post
    I'm sold on the Generic Content concept as a base for custom modules.  Reusing its capabilities makes sense for all of my "content" modules.  We are currently migrating our site to SF3.7.  In our site, we track everything the user does every action, every click.  We do some pretty fine grained, real-time reporting on this; more than we could do with an analytics tool like Google Analytics.  We have a db table that records everything: who, when, which module, what action (CRUD), which data, IP address, etc.  It grows very fast and is quickly approaching 100 million rows.  I'm not feeling it, but still, I have to ask if GC would be appropriate.  We could "categorize" hits by module or site area.  We could "tag" them with action (CRUD).

    Is there a cost to using Generic Content based modules?  Is it lightweight (as a single table)?  Is it fast (as a single table)?  Can complex queries be run against them.  For example, could we quickly retrieve items by querying against multiple fields (like entered date and entered by), category, tags, and metafields (like ipaddress, etc.)?

    I don't want to go down that road if it's not a good fit.  :)  Thanks for your thoughts.

    Jeff
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    20 Jul 2010
    Link to this post
    Hi Jeff Vail,

    The database should not be problem if you have have enough storage and proper SQL server. The problem is how many items you want to get or enter at the same time. Getting more than 100 ( say 500) items on a single load will result in the performance. For the backend( admin part) we use web service which gets no more than 50 items and then bind the RadGrid control. This ensures that there is no some impact related to the performance or SQL server peaks. There are know issues if you have more than 200 categories Optimize backend CategoriesView performance in Sitefinity 3.7

    All database queries are processed through data provider and if you use SQL Profiler you will see that some of them are quite complex. The GeneircContent data is stored in multiple tables and this data provider makes proper relation.

    Greetings,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
    Answered
2 posts, 1 answered