I have an issue with huge data on my table.
Let suppose i have a table name employee_details and columns are
Emp-name | Emp-email | Emp-mobile | Emp-designation | Emp-salary
Suppose i have 1,00000 rows inside it. Then how should i structure table for best performance.
100000 rows are not a big deal for Mysql. They are designed to handle millions of rows. Make sure your datatypes and indexes are setup properly and you should be good.