I think we can enable the commented group and can add this in entityengine.xml. Definitely it will increase one database creation, but if user doesn't want to create new database user can use same data-resource used for org.apache.ofbiz package.
Others opinion ? Thanks & Regards -- Deepak Dixit www.hotwaxsystems.com On Mon, Dec 22, 2014 at 2:52 PM, Jacopo Cappellato < [email protected]> wrote: > Thanks to all of you for your valuable feedback. > The first pass of this work is now complete, please refer to rev. 1647271 > > Jacopo > > On Dec 18, 2014, at 9:47 AM, Jacopo Cappellato <jacopo.cappellato@ > 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 > >
