Re: model connections to multiple DBs
Re: model connections to multiple DBs
- Subject: Re: model connections to multiple DBs
- From: Henrique Prange <email@hidden>
- Date: Mon, 04 Apr 2011 19:16:04 -0300
Hi Anjo,
On 04/04/2011, at 14:25, Anjo Krank wrote:
> Depending on the actual data, the memory consumption won't be any different in comparison to a solution based on a shared DB.
>
I haven't explored beyond that simple experiment. So, I can't confirm.
What I have learned with this experiment is:
1) Yes, EOF can handle a multi tenant architecture with a single model and multiple databases/stacks. I haven't faced any technical problems fetching, creating and editing data using this architecture.
2) Yes, memory consumption is higher if compared to a multi tenant architecture with single model and single database. But it is much better than the sum of the memory consumed by each application in a single application per tenant approach.
3) No, EOF is not optimized for this architecture.
A superficial analysis of memory consumption even in that simple example reveals some points for optimization in the EOF code. Certainly, EOF could handle this architecture in an improved way after a few hacks. :)
In conclusion, if the number of expected tenants per application is relative low (let's say up to 50 tenants) this approach is reasonable. If the number of tenants is expected to be much higher then it is impracticable without optimizations.
Cheers,
Henrique
> Only the reference tables could be re-used, all the other data belongs to the tenant anyway. Add to that the larger size of the individual records (you'd need the tenant references in most items) I'd be surprised if it actually amounted to a large difference.
>
> Cheers, Anjo
>
>
>
> Am 04.04.2011 um 18:13 schrieb Henrique Prange:
>
>> I have created a prototype with the intent to evaluate this kind of solution. You can download the source code from GitHub [1]. It uses a very simple model and it is not feature complete, but you can easily verify the memory consumption problem.
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden