articles in database ?
| From: | Nick | Date: | Mon, 17 Jul 2000 14:42:48 +0000 |
| Subject: | articles in database ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1188@lists.php.net to get a copy of this message | ||
Hi,
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 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 ?
nick