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.
- php - about changing the character code
- php - update does not work
- i want to delete all db table data from php
- after getting the minimum value with php, i want to get a number that does not match the minimum value in the database
- php - [wordpress] acquisition of whether there is a comment field (status?)
- php - join and display tables in sql
- php - there is a phenomenon that does not scroll in safari on macos
- about code for creating tables using mysql and php
- cannot get id column array using select statement in php and mysql
- php - i would like to know the wordpress development procedure on site