Re: articles in database ????

<<<<<< i am thinking about doing a database to put a magazine online. Basically, we would have an authors table, an issues table, an articles table etc.... Basically, I was hesitating about whether to put stuff like the actual article text (BLOLB/ TEXT) directly into the databse, or whether to put it in a seperate TXT or HTML file in a sepcified directory, bearing in mind the articles would have to be searchable. >>>>>>> i choose the first option, and you have given the reason ... :) <<<<<<< I was also wondering whether it would be more advantageous to put binary data, such as pictures, directly into the DB ( which i guess would speed up loading time) or whther to put it in seperatefiles (which iun the long run would help keep the db manageable, and thus speed up db searching).... Any thoughts on this ? >>>>>>> i say it depends on your client :), if they know how to type something like "images/my-picture.gif" into the form we made, then i prefer to put only directory path into database. - eris