Hello, i've got 2 questions, first of all im creating a software to track the entrances and the exits of the cars on a parking lot, but to avoid system lag and future problems loading data, i would like to have a temporary table only for 24 hours and this temporary table will update the table that has all the data.With that i want to have another table with all the data that was inserted from the beggining. How am I going to figure out a way to tell the program that? Any sugestions?
What I have tried:
Looking for any sugestion, I dont really know how to figure it out. Apreciated!