Is there a preferred method to archive data when a table starts getting large?
I have indexes on the commonly searched columns but queries still seem to be getting slower as more data is added into the table. I was thinking of making it into two tables. One table of data that is used frequently. One table for historical purposes. Is there something else to consider?
