I've finished up the work, so I've set Reactor to be in "production" mode
(as I have with ColdSpring too), but Reactor still seems to be hitting
the
DB twice for each query:
If reactor is a bean in ColdSpring, you'll need to reinitialise your
ColdSpring beanFactory.
Restarting CF is the quickest way to do that.
Hi Tom, cheers for that.
No, I've not quite got to that stage of nutting things out yet, so my calls
are straight to Reactor.
And, yeah, I restarted CF after updating the XML files and re-running the
request a few times to watch the query activity.
So I SHOULDN'T be seeing Reactor requerying the DB schema for each select
query it does?
I've just cranked up the site again, and am grabbing the SQL debugging.
I'm sitting on one page which lists some galleries (this is Ray's tutorial,
remember), and the query debug changes for each reload.
About 1/3 of the time I get one query for the schema, one query for the
actual SELECT. The other 2/3 of the time it just runs the SELECT query by
itself (it might be 1/4 vs 3/4, but you get my drift).
Does Reactor re-check the schema every now and then, at runtime?
Am I correct in thinking that Reactor doesn't actually generate the SELECT
query SQL to file, and then use that, rather it queries the schema
(periodically), and generates the SELECT query SQL dynamically every time a
SELECT query is run, based on that cached schema?
Thanks for your speedy reply mate. Good stuff.
--
Adam
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
