How to manage lacs of data in one table
In database,there is one table named tblRecord in which daily 1000 records get inserted, after 1 month there would be 30000 and in one year 360000. If this happened then it would be difficult to retrieve the data from this table. Please suggest me, how to manage this much data or more than that.