In the CF administrator debugging screen, turn off "Report Execution
Times".
This really slows things down in development mode.
Chris
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roland Mai
Sent: 17 July 2007 15:02
To: [email protected]
Subject: Re: [Reactor for CF] Reactor and MSSQL
Oh, I put in production and it was much faster. This is great.
However, I would like to see the dev environment to be a little faster
than that.
Thank you all.
On 7/17/07, Terry L Schmitt <[EMAIL PROTECTED]> wrote:
Change "development" to "production" in your reactor.xml
file.
Terry
------------------------------------------------------------------------
------------------------------------------------------------------------
--------------------------------
This is a PRIVATE message. If you are not the intended
recipient, please delete without copying and kindly advise us by e-mail
of the mistake in delivery. NOTE: Regardless of content, this e-mail
shall not operate to bind CSC to any order or other contract unless
pursuant to explicit written agreement or government initiative
expressly permitting the use of e-mail for such purpose.
------------------------------------------------------------------------
------------------------------------------------------------------------
--------------------------------
"Roland Mai" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/17/2007 05:47 AM
Please respond to
[email protected]
To
"[email protected]" <[email protected]>
cc
Subject
[Reactor for CF] Reactor and MSSQL
Hi,
I am using reactor (svn check out) but it appears that
reactor is doing too many useless queries and taking too long (7-8
seconds) to load.
The problem is with the query in qFields in readFields
in mssql/ObjectDao.cfc where the INFORMATION_SCHEMA is being queried to
get the columns.
I can see that this query is necessary to generate the
CFC that handles the record for my table; however, the record is part of
a HUGE database with many fields and querying INFORMATION_SCHEMA all the
time a REALLY bad idea.
Is there a way to avoid this?
I tried disabling reloading, scaffolding, and debugging
but still my debug messages seem to show that the INFORMATION_SCHEMA is
still being queried.
Any ideas?
Roland
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
