You might want to have a look at partitioning that table. It'll be a considerable
downtime, but if done right it'll speed up a lot of your selects.
----- Original Message -----
> From: "Adarsh Sharma" <adarsh.sharma@stripped>
> To: "mysql" <mysql@stripped>
> Sent: Tuesday, 15 November, 2011 11:39:41 AM
> Subject: Re: Select data from large tables
>
> More than 20163845 rows are there and my application continuously
> insert
> data in the table.
> daily i think there is a increase in 2.5 Gb in that table.
>
> Thanks
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
