+1 It will be really great enhancement. Disabling logging to these entities because of increased load shouldn't be a choice for sure.
Thanks, Pranay Pandey HotWax Media www.hotwaxmedia.com On Thu, Dec 18, 2014 at 2:17 PM, Jacopo Cappellato < jacopo.cappell...@hotwaxmedia.com> wrote: > > Visit/Visitor/ServerHit/ServerHitBin (and the related *Type entities) are > used to gather statistics about how clients use the OFBiz instance. > The information in these entities is not used by business processes but it > is very important to analyze the system performance, user's behavior etc... > This simple data model is very powerful because can capture very granular > information about each visit. > > The disadvantage is that it can add significant load on the database > server and can impact performance; on servers with high users load these > tables can be huge; in fact, in most production instances the granular > logging is disabled. > > I am proposing here a change that should make the stat gathering > subcomponent more flexible, clean and powerful, and increase the > performance of the system: > 1) remove all the fk dependencies from business entities to the > Visit/Visitor/ServerHit/ServerHitBin entities > 2) assign the Visit/Visitor/ServerHit/ServerHitBin (and the related *Type > entities) entities to a separate entity-group > 3) in this way it will be easy to configure the entity engine to store > them in a separate database (e.g. a NoSQL db); by default we could keep > them in the same db where all the other entities are > > What do you think? > > Jacopo
