Text file instead of DB

Anon

How can I convert my current website from pulling from a DB to just pulling from a text file? I am pulling maybe 10 records and it is just eating up my limited DB space. I know it will eat more of the system but I am not concerned with that to much. Any suggestions would be nice. It simply pulls 10 names by catagory. So I would need it to be like CAT1 Name and CAT2 name when it pulls. I have been playing with it but I am not figuring it out. Anyhelp would be appreciated. Ty.

[deleted]

Q: how many records are you using for that?
and have you looked at just now much DBspace it is taking up?

Re-programming it all in PHP is just plain stupid. :-)

Anon

It does not take up much. There is about 10 total records. The issue is I am trying to write a new website that is very heavly dependent on a DB so I want to free up as much space as possible. And since it is not a large number of records I would think it would be wasier to simply do it in a txt file instead of the DB.

[deleted]

"And since it is not a large number of records "

...then it wouldn't matter much if they are in the database too would it? :-)

The thin is, whatever you want to do with those records in a textfile, you will have to write the functionality yourself. That basically means that you have to write a database-engine. Plus you get into all kinds of nasty file-locking problems (on file can be written to by one script at a time)

That may be ok for a few records, but experience shows that it never stays at 'just a few records'.

Plus, sooner or later you'll want to link those records to the other databasedata, yada yada yada, you end up storing them in the database anyway. 🙂

I don't think it's worth the trouble...

A forum, a FAQ, what else do you need?