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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
