Here’s What People Are Saying About Mysql Database Optimization For Better Performance

Email– type: varchar and length: 200 (This means you give to email maximum 200 characters and type is a variable character).
UserName– type : varchar and length: 100 (This means you give to email maximum 100 charaters and type is variable character)

This length can increase the time of the processing of the website and if you have many of the fields like these your website might be slow somewhere.
Solution: Give length to the field which is required only Means, you can think 200 is a very big character length for email, no one has an email with 200 characters long.
So give required value to the length of the field. And also same for UserName field for this example.

1. The second thing is when you write some query on PHP code like given below,
   

   Query:

   $query = "SELECT * FROM table_name";
   OR
   $query = "SELECT field1, field2, field3 FROM table_name";

   Somewhere both are the same but the only thing is 2nd one is optimizable where 1st one is not.
   Reason For:

   $query = "SELECT * FROM table_name";

   When you use this code, on output this query selects all the fields of that table which is take more time than 2nd query. Beacuse on 2nd query we call only those fields which we want or required for our program.

   So always code like this for better optimization.