Member Avatar for mr. y

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

  • 3 Contributors
  • 2 Replies
  • 158 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for pritaeas

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.

Edited by pritaeas because: n/a
Be a part of the DaniWeb community

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