best method for 900 million row in read-only mysql database?

  database, mysql, performance, php

i have csv file and will import it to be a mysql database
just one table with 900M row like this

one table with 11 column
first two column is 13 digits (userid1)(userid2) and the rest is one digits and i don’t need to write on it just read

6050671682120,6533016366779,2,1,2,2,2,1,1,2,1,

and i will use php page to search in this 900 million row
only userid1 & userid2 and get user all row results 1,2,1,2,

what is the fastest way to get the data and also downsize it and server requirements for average daily search will be around 1000 to 5000

thanks

Source: Ask PHP

LEAVE A COMMENT