No problem, just performance question (a little ot)

From: 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

« previous php.general (#148122) next »