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.sha...@orkash.com> > To: "mysql" <mysql@lists.mysql.com> > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
