Hello, I have a table with a large number of news articles. Articles of type 'feature' (identified in the article_type field) will have the path to an image associated with the article stored. The question is whether to 1) add a field to the database that most records will not use OR 2) add a table to hold image path names and require a JOIN in order to retrieve.
I am thinking that the join query will be best. Thanks for any help. olinux Table setup is: CREATE TABLE articles ( id int(12) NOT NULL auto_increment, type varchar(15) NOT NULL default '', region smallint(1) NOT NULL default '0', date varchar(35) NOT NULL default '0', author varchar(30) NOT NULL default '', title varchar(90) NOT NULL default '', summary varchar(255) NOT NULL default '', content text NOT NULL, keywords varchar(150) NOT NULL default '', filename varchar(30) NOT NULL default '', PRIMARY KEY (id,id) ) TYPE=MyISAM; __________________________________________________ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
