Mysql table with lots of data

Asked

Viewed 104 times

2

Case in point: 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 performs a query will need to search these 5 million records.. Can cause server overload? What is the best way to develop in this case?

mysql quest
  • 1

    Table partitioning and caching of the most accessed items are options.

1 answer

2


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

Browser other questions tagged mysql quest

You are not signed in. Login or sign up in order to post.