|
You should be able to get incredible performance on simple UPDATEs with MySQL. Before giving up on your updates, I'd like to see your table and queries. If the table is just contains a file id (are you using an integer or an indexed filename) and a count, then it should be blazingly fast as you'd only have one key. What other data are you storing that requires indexing? I'd also be interested in knowing how many queries you're throwing at the database per second, and what the CPU load is for the mysqld process / hardware in use.
Curious to know what optimizations you've made for performance. As an example, unless the data is very important, one thing you might consider doing is stop binlog-ing it.
Most people I know really only care about unique page views anymore. They usually use third party software (awstats was one I used many years ago for instance) or a service like google analytics.
It's nice to know not simply how popular a page is, but where are people coming from, where do they end up after viewing the page, where are they geographically located, what correlation exists between the page's popularity and a sales lead or purchase, etc..
As for your question, what would I do? It depends upon what data I need to collection and how I intend to apply the information.
|
