I would say that is potentially the optimum way of doing it -- no queries at all...
If you have built the frontend of your site using well organised CSS this makes life lovely... basically when content is updated in the CMS you write an .htm (or whatever) file to the frontend which is named with the contentID... basically you get your frontend cfm pages to include the relevent file when required. Another beauty of this method is that your website administrators can make loads and loads of change on the database without it appearing on the live website until they choose to publish it (which then writes the files). Even better is that you could write XML files from your CMS and serve up content depending on the browsing application... I did post on this b4 musing about what options there are for speedy sites and decent content management... I personally think this is the best for a small / medium size site. d ----- Original Message ----- From: "Matt Horn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 10:33 AM Subject: Re: [ cf-dev ] Performance > storedprocs are great as the are semi precompiled but if the datapath > changes on each query you wont see much performance enhancement > > one way to increase performance is to cffile the most visited pages down to > HTML pages and serve those up instead of the CFML if no updates have occured > since the last page request > > *not too sure how its done but I know it can be > > Matt > > ----- Original Message ----- > From: "Allan Cliff" <[EMAIL PROTECTED]> > To: "CF - List" <[EMAIL PROTECTED]> > Sent: Wednesday, October 22, 2003 11:32 AM > Subject: [ cf-dev ] Performance > > > Anyone like to share their opinion on improving coldfusion speed either by > using stored procedures or caching queries? > > Which one is better? Or does it depend on the query. > > At the moment I have a mixture of them both with dynamic queries as SP and > basic queries q_GetCountries and q_GetStates as CachedWithin. > > Any comments? > > Thanks > > Allan > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]