- Original Message -
From: "Jan Namedyński" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 10:02
Subject: Re: deleting old records VS. index on datetime field (que
Rolf Hopkins wrote:
>
> That all depends.
>
> Do you need to keep the data for historical purposes?
I don't have to but I want ;-). it means that if speed difference would
be small I will.
Are your queries
> running particularly slowly? Have you read the manual about how you can
> optimize
wrong.
- Original Message -
From: "Jan Namedyński" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 21:09
Subject: deleting old records VS. index on datetime field (question about
optimization)
> Hi,
> I have a table
&g
Hi,
I have a table
DAY : DATETIME
CAT_ID : INT
DATA : TEXT
ID : INT
and I have to extract all records not older than 2 weeks with given
CAT_ID (sorted by DAY).
query for that is very simple, but what if this table has 1 000 000
records? Do you think that deleting records older than eg
