Re: No problem, just performance question (a little ot)

On Sun, 18 May 2003 22:41:57 +0200, you wrote: >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? a) Questions about MySQL performance will get a better response on the MySQL list b) It depends on your hardware and your database size and structure. You haven't given us the information we need to answer. Suck it and see http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=mysql+profiling 5000 requests in a sixteen hour period equates to less than one every eleven seconds, which doesn't seem onerous to me. YMMV. Have you considered appending your statistics to a logfile (a flat file or a separate database table), rotated daily/weekly, and parsing the logfiles only when you want to review statistics? That's the way these things are usually done.