BULK DATA HANDLING 0.5TB

[Krishna Chandra Prajapati]

Hi guys,

I'm working in a telecom company. I have table called deliverylog in which
30 million records gets inserted per/day. The table has grown to 0.5TB I
have to keep 60days record in the table. So, 60days * 30 million = 1800
million records. The query is taking a lot of time to fetch the result.

Please sugget me what storage engine must be used and how i can get the
things done. Is there any other alternative.

Any response is highly appreciated.

Thanks,
Krishna