Re: unnormalize db here is more efficient?

2008-03-05 Thread Thufir
On Tue, 04 Mar 2008 15:04:30 +0100, Nacho Garcia wrote: or count the comments on elements_comments table. I guess the last option could be very slow with lot of rows because mysql has to scan all of them .. and the first option seems to be very fast. I would certainly want to be able to:

unnormalize db here is more efficient?

2008-03-04 Thread Nacho Garcia
Hi, i hope this is the right place for this basic question. i have a table like this: TABLE elements `id_element` INT UNSIGNED NOT NULL , `name` VARCHAR(100), `date` DATE ... and other table with the comments of every element. TABLE elements_comments `id_element` INT UNSIGNED NOT NULL ,