Hi All,
Im using MYISAM mysql version 4.0.1 and i have a problem , one of my table will grow in our application daily.Suppose if a person running our application for one year he will have 20 million rows in the table.Is there a way to optimize it meaning can we split this table, or can we write the data to a file and while reading we will red it from the file.

my table will look like this,

ID,ATTRIBUTEID,Starttime,Endtime,MinValue,MaxValue ,TotalValue,RESOURCEID

Kindly give your valuable feedback

Thanks n Advance
Arunkumar.P

I'm not 100% sure if this will work with 4.0.1 (mainly because i can't be bothered to look at documentaton) but MyISAM tables can be split (striped) using the following syntax :

ALTER TABLE `<table>` RAID_TYPE = STRIPED
RAID_CHUNKS = 2
RAID_CHUNKSIZE = 64;

What sort of application is it and what does it do? How often is data being written/read ?
You could create a history sql script which you run periodically to cull the information in your table and pop it into a secondary (history) table.