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:3
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
Chris Tate-Davies wrote:
How many rows is that???
On Tue, 2011-11-15 at 16:05 +0530, Adarsh Sharma wrote:
Dear all,
I have a doub
