Is it a problem with overall performance or individual cfm templates? Is it the CF that's slow or the Oracle queries? If it's Oracle, it may be poorly structured queries, inefficient design of database tables, lack of or misuse of table indexes, Oracle configuration mistakes?
I think that before you go about trying to solve the performance problem, you need to identify the part of your system that's the bottleneck. --- "Emily C. Grossman" <[EMAIL PROTECTED]> wrote: > I have re-written an app using all stored procedures > and it still runs too > slow (it's a series of parent-child query loops) so > I'd like to move all > conditional processing to the db and run it all in > one sproc... > > is this at all possible using referential cursors? > Can I return conditional > cursors? Basically either one result set, two result > sets or four would return > for each major record... > > Or am I going about this all wrong? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
