Just to back up what others have already said, I would focus my energies on the database, look at the queries - are they all using the correct indexes, could you do with some additional indexes? Is the code using stored procedures, do you have the fastest available drivers? I think that's where you'll gain the most.
Kola >> -----Original Message----- >> From: Colm Brazel [mailto:[EMAIL PROTECTED] >> Sent: 01 July 2004 09:30 >> To: [EMAIL PROTECTED] >> Subject: RE: [ cf-dev ] streamlining an MX app >> >> Hi, >> >> Look at Application.cfm for sitewide variables, use of cfincludes, >> reusable components, most of all optimising database, indexes, consider >> stored procedures...large project use clustering..next ver of CF will be >> able todistribute application instances across servers, database on another >> box, SQL server nb security audit....my 2p >> >> Colm >> >> -----Original Message----- >> From: Jolly Green Giant [mailto:[EMAIL PROTECTED] >> Sent: 30 June 2004 22:16 >> To: [EMAIL PROTECTED] >> Subject: [ cf-dev ] streamlining an MX app >> >> >> Guys, >> >> If a client were to come to you and say that they have a project for you, >> and that the job was to "increase the performance and stability of a Cold >> Fusion MX application", what "flags" pop up for you right away? >> >> Things like... >> ... check to see if any queries can be cached? >> ... be sure all session variables are locked properly, if appropriate? >> ... decrease use of CFML custom tags where possible to reduce overhead? >> ... notice locations of multiple cfset statements where cfscript would be >> better? >> >> Those were a few that came to me right away. But I am interested in what >> you all think as well. >> >> Thanks, >> >> David /jgg >> >> >> >> >> -- >> These lists are syncronised with the CFDeveloper forum at >> http://forum.cfdeveloper.co.uk/ >> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ >> >> CFDeveloper Sponsors and contributors:- >> *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided >> by activepdf.com* >> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by >> proworkflow.com* >> *Tutorials provided by helmguru.com* :: *Lists hosted by >> gradwell.com* >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> >> >> --- >> avast! Antivirus: Outbound message clean. >> Virus Database (VPS): 0427-0, 29/06/2004 >> Tested on: 01/07/2004 09:29:27 >> avast! is copyright (c) 2000-2003 ALWIL Software. >> http://www.avast.com >> >> >> >> >> -- >> These lists are syncronised with the CFDeveloper forum at >> http://forum.cfdeveloper.co.uk/ >> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ >> >> CFDeveloper Sponsors and contributors:- >> *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by >> activepdf.com* >> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by >> proworkflow.com* >> *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
