>- see footer for list info -< >maybe not necessarily more efficient/faster, but certainly better okay, so you agree its not good for efficiency to store and retrieve massive amounts of text in a database?
>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 Whats wrong with using a database to store relationships between files? Using database storage, if someone puts an image into a cms container, do you then put the image into the database as bytes? or do you simply store the relationship? Enterprise level document management systems I have seen, use a database to store relationships between files. Databases are for data storage, file systems are for file storage. >Thirdly if you have to update something in all those news articles I would store standardised information such as contact info in the database, but for the actual content of the news article (whats the longest news article you've ever seen?), I would use disk caching. >Fourthly, if you need to change language from CF to anything else If you have to change the programming language of your CMS, i think you will have more issues to worry about than how the containers are stored. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 -<
