Consultation when designing a reservation system database.

With reservation schedule management,
If i create a date/time table (time table) that is registered daily by the administrator,
I think it will be a table that will be accumulated forever, but I think that the performance will worsen as it accumulates. Do you know how to maintain and avoid it?

Some people may not need to create a date/time table in the first place.

  • Answer # 1


    I think performance will worsen as it accumulates

    Generally, we don't do "do it all at once without thinking about date conditions", and if you narrow it down within the date range, you can set an index on the date column, so that even if the data increases, it is a practical performance Is possible.