search

philrhoy / IMCCVenueReservationSystem2023

Venue Reservation System 2023
MIT License
1 stars 1 forks source link

Concern regards to Row/Record Size (maximum bytes per record): its for the Capacity Plan. Chapter 4 #73

Closed ralch34 closed 10 months ago

ralch34 commented 10 months ago

Question 1: where can I find each byte size for each attribute in a selected table? (I tried looking in localhost phpmyadmin. It just shows the current size of stored records from the table.)

Screenshot_54

Question 2: in terms of practical use, is varchar(255) too big?
also, how much byte size does the data type "datetime" have? how much byte size does the data type "text" have? from columns "description and notes" in schedules?

Question 3: for the "act_form_file" and "letter_approve_file", I heard that longblob or longtext are datatype commonly used for larger file store. Why both columns are in "varchar"?

Screenshot_50 Screenshot_51 Screenshot_52 Screenshot_53

philrhoy commented 10 months ago

Q1: You can refer here for the total byte size per column in the table. https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html#:~:text=MySQL%20stores%20VARCHAR%20values%20as,require%20more%20than%20255%20bytes.

Q2: If it is not good for 255, then what is your recommended character size for an unpredictable value to be inputted by the user?

Q3: We don't digitally save the images on the database due to the need for conversion when we are going to save them as blob data. We stored the images and files in the system's file folder, named "uploads."

ralch34 commented 10 months ago

answers received