MySQL table with lots of data

Navigation
2

Example case: I have a system with approximately 5 million records, it is recommended to use a single MySQL table to save, for example tabela_empresas_brasil ? since every time the user makes a query will need to search those 5 million records .. Can it cause server overload? What is the best way to develop in this case?

    
asked by anonymous 14.09.2016 / 17:21

1 answer

2

Make sure to create indexes for your searches in this table, then you will have no problem with overload, 5 million records is not a data volume to worry about just for query.

    
13.11.2017 / 20:23
How do I create a fullscrenn button for my video player? How to create initialization script in Debian by modifying environment variables