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.