It doesn't matter. The issue is that in dev mode the data for ALL reactor objects (including metadata, gateways, daos, validators, etc.) is recreated on every request. There's really no way to speed this up, that is is the point of dev mode. Unless you are actively adding tables or changing the schema you don't need to be in dev mode, just put it in prod mode which is obviously much faster since all of this data is cached after initial creation.
Hope that helps, Brian On 7/17/07, Roland Mai <[EMAIL PROTECTED]> wrote:
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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
