I did turn that off a long time back and I saw improvement.
However, in dev the app is slower. The server is running windows. I wonder if that matters. On 7/17/07, Chris Blackwell <[EMAIL PROTECTED]> wrote:
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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
