working on a system with 2 tables both have the exact same fields - the tables are past_participant and course_participant - CP table has all current students whilst the PP has only past students.
after a course concluded, that set of students is transferred from CP to the PP table.
is this a good practice? is it better to just have one table with an extra field called type which will define if its a past or current participant?
we are having 2 tables thinking having one might just slow down the search... is this right?
is it better we are having 2 same tables which are the same or just one table with an extra field that defines the type?