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? 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
