The best way of doing...
Posted: Sun Dec 14, 2008 7:52 am
Well i'm wondering the best way to do something, this 'something' is a diary to test my PHP and stuff and im wondering whats the best way of storing diary entries?
I think the best way would be to have a MySQL database named 'Diary Entries' and then have tables named after each user? But what is the maximum size of one database/table as i dont want to have to spent alot of money on hosting, if i chose to release it..
So say i got 1000 members... how many databases would i need total to hold those? Because i dont want to have to fork out tons of money for databases if it becomes popular..
So yeh any suggestions, like the best way to do it?
I think the best way would be to have a MySQL database named 'Diary Entries' and then have tables named after each user? But what is the maximum size of one database/table as i dont want to have to spent alot of money on hosting, if i chose to release it..
So say i got 1000 members... how many databases would i need total to hold those? Because i dont want to have to fork out tons of money for databases if it becomes popular..
So yeh any suggestions, like the best way to do it?