>- see footer for list info -< My idea was to: 1. Always save content to the database 2. Have the option of whether to write the data also to a flat file.
This will work fine until you decide to change something in a menu / layout for example which would affect every page so I would have to build some sort of file to republish the site after menu / layout changes. Files which are correctly named / structured should SEO equally whether or not they are dynamic. Just as long as you are not using query strings, I tend to use fusebox and this has caused some problems with SEO so may be moving away from fusebox for the front end of this app. Let's not start that whole fusebox debate pls. If I save the files to htm then I have the problem that I cannot log / track visitor activity through coldfusion (unless I tell coldfusion to parse htm files too which would defeat the object) so I was thinking of saving them to flat cfm files with the logging an include in Application.cfm . Also have to see how big pages are because over 64000 won't save to a text field. Many pros and cons for each way, so I am in the process of taking the pros and putting them all together. Allan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Duncan Cumming Sent: 19 August 2005 13:09 To: [email protected] Subject: [Maybe Spam] RE: [Maybe Spam] RE: [CF-Dev] CMS >- see footer for list info -< >>> [EMAIL PROTECTED] 19/08/2005 11:57 >>> 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. I agree - but I think Kerry is advocating not even storing the content in the db, if I'm reading her correctly, but in just flat files? "personally, i would write to .cfm and include the content." > Flat files are also more search engine friendly Really? How so? Given that Google et al will index dynamic sites, or you can use url rewriting to achieve SES URLs? -----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 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 >-< _______________________________________________ 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 >-< ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________ 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 -<
