I have a table where there is about 1 milliard record.
when my website is on high traffic, there is more than 100 requests/second on this table.
so request respond time is between 2-4 seconds, which leave a bad impression.
is there any suggestion how to minimize the request respond time on high traffic?
i am working using php mysql.
any suggestion is appreciated,
thanks for you help,