Re: [GENERAL] EAV Designs for Multi-Tenant Applications

2017-10-15 Thread Alban Hertroys
> On 12 Oct 2017, at 16:48, Nic Pottier wrote: … > We have thousands of organizations, some organizations have hundreds of > custom fields. Some organizations have millions of contacts. We have tens of > millions of values across organizations, so relatively sparse with a large > number of t

[GENERAL] EAV Designs for Multi-Tenant Applications

2017-10-12 Thread Nic Pottier
Howdy all, We maintain a hosted multi-tenant system for a large number of users. Each user has what we call an "organization" or "org" which is their sandbox. In that organization they can manage contacts and define custom fields on those contacts, which then have values per contact. We have thou