Ive got a very deep hierarchy of tables and im running into performance
issues when having to retrieve the entire hierarchy or Records. The
performace issue comes due to reactor having to run a query for each
Record. So, i built a function in the highest Record of the hierarchy to
query all of the tables and set the hierarchy of Records manually by
calling each of the individual set[column_name] functions. This way one
query sets the entire hierarchy of Records. It works great until i get
to the one-to-many relationships. I cant seem setup an iterator so that
it never has to run a query. It seems that iterators *must* run the
variables.queryObject in order to properly initialize itself.
Is this true? Is there a better way to do what im trying to do (set an
entire hierarchy of records w/ 1 query)?
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
