Re: articles in database ?

It depends. Do you want to let users be able to search all BLOB or TEXT fields? If you have a big tables that would take a long time to search. Do you want to consider using keywords in other fields to support this search? Then use the index to pull out the data from the table that contains BLOB/TEXT fields. It will be much faster but then you can't search every single word in your articles. Depend on the power of your systems, you choose your method. For images, I prefer to put images in file folders instead in the database. Database management and speed costs more then load time, in my oppinion. Nam.

From: "Nick" <nick@carrierworld.com> To: <php-db@lists.php.net> Subject: [PHP-DB] articles in database ? Date: Mon, 17 Jul 2000 15:42:48 +0100 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

________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com