Upon further looking, it seems that although having so many models is bogging things down, it is really the calling up those model across multiple databases that may be the real culprit.
When I incrementally introduce each method call in the Controller’s function, the time it takes to load the page jumps by about 5 seconds each time a new DB is introduced, while staying the same if the new call/query is from a DB already called. d_admin site, flight, spot, listing, errorlog, category 7 membership memberdata, membersite 12 crm crmcase 17 session_Mngr sessions 22 reporting statspvpoid 30 -- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en-US.