Marc,
I've ran into a few problems in my deployments with Reactor and it
simply came down to some poor coding choices that I made. One trap I
fell into is generating an array of objects instead of just returning
a query. It's great to have this array of objects to loop through
and it makes it really easy to call child objects, but returning
anything more than a couple of records will kill the performance. I
ended up spending a little more time creating joins and returning a
query.
This is the single greatest thing I did to improve the speed of my
apps and reduce the load on the server.
Brad
On Dec 15, 2006, at 6:06 PM, Marc wrote:
Well, we got our survey app online, after finally figuring out that we
needed reactor to be in a directory in the root of our app with no
mapping.
The client broadcast to his mailing list to take the survey, and lo
and
behold, our robust server is just choking... And it's really not
THAT many
users at once. Of course, it's all my fault, so I need to ask for
some help
at this point. I didn't even think to ask him how many people were
getting
the newsletter/notice of the survey, and reactor had been
performing well in
my tests -- though I did not have time to perform proper load tests
on this
app, nor do I really have the tools to do so.
We are in production mode. There's a lot of questions in the
survey, but
they are delivered in "pages". The database server is not really
under a
lot of load overall, so this really seems to be a CPU usage issue.
I'll answer any questions that anyone willing to help would like to
ask, to
help us get this completed app running better than it is. I think
we need
to look at caching the queries that pull the questions onto each
page as the
page is loaded, and we may need to look at how the answers are
stored back
to the database as well. For each answer on the page, there's a
database
insert. I can also provide our dB schema.
But first I thought I'd check with everyone, to see if there's some
additional "performance related setting" I should check, within
reactor.
Caching, mode, etc.
I'm not sure if this should be taken off-list or not, but there will
certainly be a reply back to the list when it's OVER, to make sure
nobody
makes the same mistake I have just made.
Anyone care to join me in hell's cubicle for a little while?
marc
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
