Deactivating Ad views counter
-
Hello,
Is there any way, without editing plugin, to deactivate ad view counter?
I would like to deactivate it, because of slow mySQL update queries.MySQL update query take about 0.0233s (per Ad). For 6 ads update process can take up to 0.2s and more..
Example for 4 Ad count updates:
0.0446s | UPDATE wp_sam_ads SET wp_sam_ads.ad_hits = wp_sam_ads.ad_hits+1 WHERE wp_sam_ads.id = 1; 0.0233s | UPDATE wp_sam_ads SET wp_sam_ads.ad_hits = wp_sam_ads.ad_hits+1 WHERE wp_sam_ads.id = 3; 0.0195s | UPDATE wp_sam_ads SET wp_sam_ads.ad_hits = wp_sam_ads.ad_hits+1 WHERE wp_sam_ads.id = 4; 0.0197s | UPDATE wp_sam_ads SET wp_sam_ads.ad_hits = wp_sam_ads.ad_hits+1 WHERE wp_sam_ads.id = 5;
while select is of course fast (0.0009s):
0.0009 | SELECT wp_sam_ads.id, wp_sam_ads.pid, wp_sam_ads.code_mode, wp_sam_ads.ad_code, wp_sam_ads.ad_img, wp_sam_ads.ad_alt, wp_sam_ads.ad_no, wp_sam_ads.ad_target, wp_sam_ads.ad_swf, wp_sam_ads.ad_swf_flashvars, wp_sam_ads.ad_swf_params, wp_sam_ads.ad_swf_attributes, wp_sam_ads.count_clicks, wp_sam_ads.code_type, wp_sam_places.code_before, wp_sam_places.code_after, wp_sam_places.place_size, wp_sam_places.place_custom_width, wp_sam_places.place_custom_height FROM wp_sam_ads INNER JOIN wp_sam_places ON wp_sam_ads.pid = wp_sam_places.id WHERE wp_sam_ads.id = 5;
Thanks
https://www.ads-software.com/extend/plugins/simple-ads-manager/
- The topic ‘Deactivating Ad views counter’ is closed to new replies.