sql server – database design storing historical information


I have this database table Templates and I need to keep historical information. So in code what I am doing is inserting a new row with the updated data and then setting the IsCurrentVersion flag to false. This is working fine but I am not sure how this will grow. Will that have performance problems? Is there a better way to do this? would a archive table be better?

Table Templates {
  id int [pk]
  Title varchar
  Added datetime
  Moddified datatime
  Deleted datetime
  IsCurrentVersion bit
}

enter image description here