database vs. textfile 1

[TempestT37]

Can someone describe the pros and cons of using a database vs. textfile.txt for storing small bits of information like Newsletters, phone numbers, guestbook entries or page counters? Which is faster? Which one requires less server resource?

TIA
Michael

 

[Bullschmidt]

A database would be more efficient and versatile. For example what if you want to use more than one table? Or a step up from that what if you want to use data combined from more than one table? Databases are designed to store and retrieve data quickly and one can even index certain important fields to make things even faster.

Best regards,
J. Paul Schmidt

http://www.Bullschmidt.com

- Freelance ASP Web Developer

http://www.Bullschmidt.com/DevTip.asp

- ASP Design Tips

 

[Bullschmidt]

And of course on the other side a text file can be opened by anyone with a text editor and the Web host does not need to be able to support a particular database such as Access.

Best regards,
J. Paul Schmidt

http://www.Bullschmidt.com

- Freelance ASP Web Developer

http://www.Bullschmidt.com/DevTip.asp

- ASP Design Tips