Skip to main content
2 of 6
edited title
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531

How to optimise a table to read/write table with one column having 141455500 rows

I am developing django application where i used database as mysql ,in my application there is one table for domains information which has only 2 coloumns

id domain name

but i get problem when i have import almost 14150000 DATA in that record i have not done any optimisation yet and there is also a posibility of importing more 14123500 records.

right now i am not able read that data in myapplication.

which steps i follow to perform a read,search operation faster ..

Any one have idea please tell me

thanks pritesh