Re: Very long query doubt... (Monster query...)

[Toni Lopez]

Hi!, thanks for your answer

Maybe from today until may or july, I will have the 30% (or more) of the rows matched with fecha >= '2008-01-01' and fecha <= '2009-01-01', but the table will increase its size...4M per year, more or less, so I cant count with that...


cod_serie --> smallint? oh! It's a great idea! But that will not affect into my problems... I will change it anyway...

or's into unions??? mmm, I will think about it, how to make "the transformation" automatically ...

I have a Xeon double CPU with 1GB RAM, dedicated only to MYSQL services...

key_buffer_size  	419430400

I've had changed it before, trying to find an answer...

So... I cant change any more things?... mmm well, thats means I should be patient and wait when my querys are executed...

Nevertheless, thanks for all. Any good (or not so good) ideas will be welcomed.