PHP vs mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Coco
Forum Contributor
Posts: 339
Joined: Sat Sep 07, 2002 5:28 am
Location: Leeds, UK
Contact:

PHP vs mysql

Post by Coco »

i have a large text block that i need to save for future use, but it will get changed frequently (maybe as often as once an hour)

would it be better to save this using fopen() or by having a blob field in a database?
bearing in mind that each user will have one of these fields
User avatar
llimllib
Moderator
Posts: 466
Joined: Mon Jul 01, 2002 2:19 pm
Location: Baltimore, MD

Post by llimllib »

IMHO, mysql would be better. Faster, takes up less space, no need to consume system resources opening files. Really, I can't think of any advantages to saving it to a file unless, for example, you have an overloaded db server.
User avatar
Takuma
Forum Regular
Posts: 931
Joined: Sun Aug 04, 2002 10:24 am
Location: UK
Contact:

Post by Takuma »

Just write a script that enables you to read data from the db and update it. Just a simple script that'S what I do with my website.
Post Reply