cronjobs/updateviewcount.php should be refactored to use hashes of NodeIDs and Paths found in access log and increase the counter only once per NodeID/Path, this should dramatically decrease the number of queries of the script.