Re: Update SQL
| From: | Miguel Cruz | Date: | Fri, 24 May 2002 16:44:27 +0000 |
| Subject: | Re: Update SQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-99101@lists.php.net to get a copy of this message | ||
On Fri, 24 May 2002, Richard Baskett wrote:
> I have a page that when someone searches for information.. Every hit
> that shows up on that page has an SQL update that increases a counter
> for that particular "record". Now when we have hundreds/thousands of
> users using the site.. Will this cause some serious problems since most
> of the users will be using this search and at the same time? That's a
> lot of db hits all at once isnt it?
It's nothing that hasn't been done before. As your traffic increases, the
strain on the database will increase, and I doubt this in particular will
be the straw that breaks the camel's back. Just make sure you have a plan
for moving to multiple database servers, and that plan is ready long
before the traffic has built up to that level - or you're going to be in
real trouble.
miguel