We've got an enormous amount of dynamic content and because I was fed up with the time it takes to process I wrote a seperate process that, by the click of the button, updates all or a selected part of the dynamic content.
What I actually did was dump loads of pages and each page had a series of <CFSET> statements that acted like the database read. Instead of calling the database for a query result I included these pages. It removed about 78-250ms from each call. (I suppose you could use XML here but not sure of the performance) I could have created a final html, but this did not fit in well with the dynamic nature of our content. However, it did mean part of our site continued to work when the database was down. I reduced the number of queries from about 5 each page to 1. Another way of improving performance is doing this dump in the database itself, using data warehousing techniques. Whatever you do you can only really apply this to data that is read far more often then written. If its data that changes frequently, you are stuffed. You might have to change the data model and remove columns from tables. Paolo > -----Original Message----- > From: Matt Horn [mailto:[EMAIL PROTECTED] > Sent: 22 October 2003 10:33 > To: [EMAIL PROTECTED] > 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]
