+1
Thanks & Regards
---
Arun Patidar
Manager,Enterprise Software Development
HotWax Media
www.hotwaxmedia.com
On Thursday 18 December 2014 03:20 PM, Ashish Vijaywargiya wrote:
Very Good Idea, +1 for this change.
--
Kind Regards,
Ashish Vijaywargiya
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
