>- see footer for list info -< Duncan, Generating flat files from data stored in the database makes no difference whatsoever as to how easy it is to find and edit the content, this part of the CMS is exactly the same. You certainly would have to do all that long winded looping over files and folders you speak of. You simply edit the content in the database and re-generate the flat file.
Flat files are also more search engine friendly, easier to index, and as I stated previously, have less points of failure, and thus your site will have better uptime. The only time you really need to use dynamic content, is it is changing continuously throughout the day, or if that content is being pulled in from another source. But even that can be improved by using IFRAMES that load din a dynamic page, so then the whole page is still static. Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Duncan Cumming Sent: 19 August 2005 11:44 To: [email protected] Subject: [Maybe Spam] RE: [CF-Dev] CMS >- see footer for list info -< maybe not necessarily more efficient/faster, but certainly better. there's a big advantage in storing information in a db over a flat file. It's easy to find/edit/delete data. Let's assume you're storing something like news articles as flat text files. Firstly, you're going to end up with lots of files, which are more of a handful to manage than one database table. Second you will struggle to relate that content to other content, without resorting to the db to store the relationships, which is then a bit of a cludge as you're relating db content on one side with files on the other. Or maybe relating files to other files... Thirdly if you have to update something in all those news articles (e.g. the contact details need to be amended), it involves using cfdirectory to get all the files, loop through the directory/directories, cffile to read all the files, check the filecontent contains the data you are looking, then cffile to write the amended file again. or just one query: UPDATE News SET Phone = '#NewPhoneNumber#'. Fourthly, if you need to change language from CF to anything else, if it's in a database your data will be fine. If it's a file with embedded cfoutputs etc, then you're going to have to manually fix that to work as ASP or whatever. Similarly if you ever have to export your data to another system, then it's very simple to extract and save as .xml, .csv etc. etc etc etc The only real advantage is what Russ said earlier, of having flat .html versions of your pages which will work if CF is down (also useful if you get very high traffic, as it reduces load on CF server). Duncan Cumming New Media Developer Customer Relations Management / Education Fife Council 700 4105 / 01592 414105 >>> "Kerry" <[EMAIL PROTECTED]> 19/08/2005 11:23 >>> >- see footer for list info -< Duncan, are you are saying that: cfincluding 4 pages of text, which might contain cfoutputs isnt going to be more efficient than querying 4 pages of text from your db, transferring it through your network, and then evaluating it ? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Duncan Cumming Sent: 18 August 2005 16:19 To: [email protected] Subject: RE: [CF-Dev] CMS >- see footer for list info -< >>> "Kerry" <[EMAIL PROTECTED]> 18/08/2005 15:08 >>> database = yuck, storing that amount of text in a db and then pulling it down the pipe repeatedly That's how any database driven site should work... storing your content in hundreds/thousands of files and either reading them or cfincluding them isn't going to be more efficient than querying a db. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allan Cliff Sent: 18 August 2005 15:02 To: Coldfusion Development Subject: [CF-Dev] CMS >- see footer for list info -< Me again, I am about to embark on a small CMS project and am contemplating the difference between creating directly htm pages or save the data to the db and create the page everytime. I did think about Farcry but I remember the last time I wasted 2 days work trying to get the damn thing to work. It kept asking to create some containers or something like that. I just gave up in the end. Not intuitive at all and bad documentation. Any other easier to use free CMS options or shall I write my own? Also opinions on the above, whether to write to db and create on the fly or write to htm directly. Allan P.S. Can anyone tell me if I should use a trigger or an sp? Lol _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< Duncan Cumming New Media Developer Customer Relations Management / Education Fife Council 700 4105 / 01592 414105 ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and should not be disclosed to any other party. If you have received this email in error please notify your system manager and the sender of this message. This email message has been swept for the presence of computer viruses but no guarantee is given that this e-mail message and any attachments are free from viruses. Fife Council Tel: +44 (0) 1592 414141 ********************************************************************** _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
