List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 15 2011 10:44am
Subject:Re: Select data from large tables
View as plain text  
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
Thread
Select data from large tablesAdarsh Sharma15 Nov
Re: Select data from large tablesAdarsh Sharma15 Nov
  • Re: Select data from large tablesJohan De Meersman15 Nov