Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Framework » Party
Re: Party [message #741 is a reply to message #739] Tue, 03 April 2007 12:12 Go to previous messageGo to previous message
stephenboey is currently offline  stephenboey
Messages: 54
Registered: January 2007
Member
Sad Alrite, I understand.

I have been using and implementing Siebel CRM for about 5 years.

Siebel from the start has been using Party Model too!

Hope you don't mind me sharing with you about a pitfall of having a Party table.

Siebel makes use of the Party table to control visibility of records depending on the Role of the user. When the number of Roles/Position hits about 150 - 200. Users will begin to experience performance problems when making queries. Reason being, core data like Contact (about 800000 records)/Company has a join to the Party table. In most cases, Parent and Child are residing on the same Party table.

Same with SugarCRM, I think they are using Party model as well. Because they have a table called crmentity.

So the thing about object oriented concepts being used to generalise this Party principle does have some pitfalls as well.

Some people might disagree with me, but just talking from experience ya.


 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: About webServices and WEB
Next Topic: Comparison Radicore vs. Zend Framework
Goto Forum:
  


Current Time: Thu Sep 12 19:21:31 EDT 2024

Total time taken to generate the page: 0.00924 seconds