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

Reply via email to