Re: Design question (MySQL vs flat files)

danah@home.com (Dana Holt) wrote: > I am designing a site that will have lots of "stories" on it. > > Right now, I am using MySQL to store all of the info on each story except > for the story text itself. I am writing an individual text file for each > story and storing the name of the file in the database. Is this the best way > to do this or should I store everything in the database? I don't really have > much experience with this kind of thing. There will be many thousands of > records, and I don't know how well it will scale. Well I would store it all in a database, because then I would not have to spend resources on getting the text from the file aswell as getting things from the database. And I dont think you run out of tablespace in the near future there can be from 2-4 GB in your tables (on linux systems depending on kernel) so there can be some text. -- Henrik Hansen