i am working on php codeigniter framework with mysql workbech as back end tool...I have a doubt regarding executing one of the sql query that should be scheduled for one month....like i will explain it in clear...
i have a table named packet data in that table i will get 7 lakhs of records per day so totally for 1 month i may get 2 lakhs records roughly..and my application runs mainly on this table so because of this, my application runs slow....
So i want to move every month of data to a dump table and should be deleted from the main table so that my application may run fast....
This copying of 1 month data should be done every month and should be deleted form the main table.....
Please can anybody give me the solution how to perform the same delete and copy queries that should be performed in the same query....and whether it is possible or not can u tell me....
My mail id:lakshmiswethapingali86@gmail.com
Thanks if any one responds....
0 comments:
Post a Comment