• 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.