No problem, just performance question (a little ot)
| From: | Ryan A | Date: | Sun, 18 May 2003 20:41:57 +0000 |
| Subject: | No problem, just performance question (a little ot) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-148122@lists.php.net to get a copy of this message | ||
Hi,
I have a table with around 30 fields, but most of the fields have only the
values 1 or 0.
I want to add the fields counter,month,day to the end of it so that i can
know how many times a particular record is being viewed...
I will have around 5000 records there on a pretty busy site and when someone
clicks the link to see that particular recored (for our example a record
with $cno=777)
I would 1) run a "update" for the $counter,$day based on $month and then
2)run a select to get all the data from the DB
my question is: if i get 5000 hits a day each fetching on an average of 10
records...will this put a big strain PHP/MySql?
I am on a shared server (cant afford a dedicated one).
Do you think i can safely implempt this (as i have not done so as yet) or
will the performance degrade so badly that the sacrifice for statistics too
high?
Your views are appreciated.
Cheers,
-Ryan