Fixed
Details
Details
Assignee
Michael Offner
Michael OffnerReporter
Michael Offner
Michael OffnerPriority
Labels
Fix versions
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Affects versions
Created 25 June 2015 at 08:58
Updated 8 May 2020 at 19:50
Resolved 25 June 2015 at 14:30
We are in process to add more ORM models with other databases with the datasource="another_db" option in the models.
The problem we have seen is that when you simple do a EntityLoad of any model, lucee open N connections to the DB, with N=number of distinct datasource you have in your models.
So, if you have:
model1.cfc -> datasource1 (main datasource, without datasource option in the model)
model2.cfc -> datasource2
model3.cfc -> datasource3
model4.cfc -> datasource4
And you do:
EntityLoadByPk('model1', 1);
Lucee (in my case Tomcat), always open 4 database connections and not reuse existing ones. So if you reload the page, you have 8 DB connections and so on.
We are trying to add our historical dbs (13 models) and this issue blocks us of doing it.