Re: deleting old records VS. index on datetime field (question about optimization)

2001-02-18 Thread Rolf Hopkins
. - Original Message - From: "Jan Namedyski" [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 DAY : DATETIME CAT_ID : INT

Re: deleting old records VS. index on datetime field (question about optimization)

2001-02-18 Thread Jan Namedyski
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?

Re: deleting old records VS. index on datetime field (question about optimization)

2001-02-18 Thread Rolf Hopkins
- Original Message - From: "Jan Namedyski" [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 (question about optim