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,
Mr. Y

Caching, assuming your queries/indexes are already optimized. MySQL can cache queries, PHP can cache output, find a good balance. You can also have a look at memcached.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.