Alright, I plan on making a news updating program for my website so I can stop using blogger.com (even though it works really well if you tweak it out with a bunch of PHP.) It seems like it will be easy enough to do this myself, but I would also like to take a stab at doing the autoarchiving and stuff. One thing I was wondering is if I saved every news update as a seperate text file, would that be a lot slower than saving all the news updates into ONE text file (possibly 1 month/text file or something.) So in short - is it faster to save everything to one file than it would be to save stuff to different files. If you have any thoughts, just throw em out, I would appreciate it.
it is probably faster to save everything to one file. This is because the majority of the overhead comes from opening/closing the file, not from reading the file, so if you stored info in multiple text files, you are maximising the overhead.
alright cool, thanks for the info… yeah I would like to go with mysql too for functionality and ease, but I can only have 1 database, and I’m using it for my forum. Nice to know about the file opening/closing.
hmm, I’ll have to look into eyez… I really have no mySQL knowledge, I set up a forum and had to create a database for that, and it sounded like I would only be able to use the database for the forum. my host is www.1and1.com, I don’t know if you are familiar with them or not… I’m looking at the page right now and I think I understand what you are saying about having a databse and then different tables - and that makes a lot of sense. Sweet, now I can do it with mySQL! Thanks a lot, I never would have known!
