Lucee 4.5 on Windows 10.
I have a FW/1 application. I've narrowed this down to (for example) a single simple entity load in the controller:
rc.companies = entityLoad("Company", {active = 1}, "name asc");
This entity has around 100 records. There's around 1000 in a linked "Members" entity.
With this in the controller and nothing else, it takes 60-250 seconds, even if it is the only thing in the controller and I output nothing in the view.
It's inconsistent, sometimes it will actually come back fast, sometimes 60 secs, sometimes 250, occasionally goes to 300 and times out. But usually 60-75. No obvious pattern.
Lucee in the debug information can't see it is taking this long, it is telling me the page is taking one second or less.
Tomcat when set to log page duration logs it correctly- 60-70 seconds. So Lucee is missing, or not recording something here.
The entity does have children. If I set lazy="true" on the relationships, the load will come back reasonably fast- like 3-4 seconds. I DO think this is still slow, and indicates something wrong, but it's faster. But the problem then comes back when I put the output back, it's back to glacial.
It's not specific to this one, though, I've seen the same behaviour with another simple pair of entities which were just Countries (250 or so) and States (80 or so). It seems to affect anything with 100+ records, it slows to a crawl. Possibly only an issue if relationships are involved.
Now the bizarre stuff- the exact same code is running fine in production on Railo 4.2 (on Linux) and comes back quickly (under a second).
If I take this line OUT of the FW/1 app in my Lucee 4.5 dev environment and just run it by itself, it comes back quick, under a second. That's with all the output, it's fast.
So it is some interaction of Lucee, FW/1, and whatever else we have in the app.
Any ideas? It is driving me mad. Pointers to things to try/look at appreciated.