phpAdsNew was starting to bog my site as I was using it across all my pages, about 500k impressions a day. That's half a million queries it was doing each day to log the impressions So I modified the "deferred threadviews" hack to work with this-- it logs the views to a temporary HEAP table and then when it has a good bunch, it sorts them with GROUP BY and writes them all at once. It's saving over 90% of the queries. If you have a large site using it, mail me for the mods or I'll post them here.
2101 Total Views (original number of write queries)
119 Ads/Zones (new number of write queries)
94% of Writes Avoided [1982 avoided]
18:1 Original Writes vs. Consolidated Writes
119 Ads/Zones (new number of write queries)
94% of Writes Avoided [1982 avoided]
18:1 Original Writes vs. Consolidated Writes
Comment