----- 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 (question
about optimization)
> 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.
If your queries are running at acceptable speed levels, keep them. If it
becomes too slow, you could first do performance tuning and then export the
data out of the DB and tar them up.
>
> Are your queries
> > running particularly slowly? Have you read the manual about how you can
> > optimize? Another thing to consider is disk space but I don't think you
be
> > anywhere near the limit yet but I could be wrong.
>
> Disk space is not the problem, but query speed is very important.
> Frankly speaking I just want to know, if table with well designed
> indexes and all records (for example from past 12 months) would have
> query execution time much bigger than table without all this records (I
> mean with records from past 2 weeks only).
>
> greetz.
> --
>
> [EMAIL PROTECTED]
>
> { http://postmoderna.com ^ design studio }
---------------------------------------------------------------------
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
