I've been talking with the guys on the reactor list this week and we seem to have determined that my problem is not with Reactor but with Model Glue.
Using reactor I can update a table in the blink of an eye. Using Model Glue it takes many minutes. In debugging the problem I found a way to speed up reactor and now my update time is down to 11 seconds which is obviously ridiculous. I've spent quite a bit of time on this and could really use some hints about what to try.
One thing I know is wrong is that the readFields function is being called 6 times per update but I can't figure out why.
I am using the modelglueapplicationtemplate with one scaffold tag
I have reactor in production mode.
I have model glue debugging, scaffolding, and reload turned off.
I have Cold Fusion debugging turned off.
I put a counter in
reactor\data\oracle\ObjectDao.cfc
cffunction name="readFields"
to see how many times it was running through the query.
Here are the results:
|
| Retest
with readFields Counter |
Seconds |
readFieldsCounter |
| init |
1.34 |
0 |
| list |
0.82 |
0 |
| add new (time for form to
come up) |
4.32 |
2 |
|
| save (time for list to
come back) |
11.94 |
8 |
|
| edit (time for form to come
up) |
0.92 |
8 |
|
| save (time for list to come
back) |
12.11 |
14 |
|
| edit
(again) |
1.36 |
14 |
| save
(again) |
12.25 |
20 |