+1 I agree with others that it is a very useful enhancement!
Kind regards Anahita 2014-12-19 11:06 GMT+01:00 Deepak Dixit <deepak.di...@hotwaxmedia.com>: > > +1 > > Thanks & Regards > — > Deepak Dixit > > > > On 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 > >