From: Johan De Meersman Date: November 15 2011 10:44am Subject: Re: Select data from large tables List-Archive: http://lists.mysql.com/mysql/226303 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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" > To: "mysql" > 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