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

Reply via email to