WordPress.org

Ready to get started?Download WordPress

Forums

Post Views Count
Problem with database (7 posts)

  1. davidin80
    Member
    Posted 1 year ago #

    Bonjour,

    Merci pour cet excellent plugin qui me permets enfin de compter efficacement le nombre de vues d'un article.

    Par contre, je viens de m'apercevoir que la taille de la base de données avait tendance a augmenter de façon exponentielle.

    En effet, dans la table wp_options, j'ai au moins 40000 lignes avec :
    - _transient_timeout_baw_count_views-xxxxxxxxxx
    - _transient_baw_count_views-xxxxxxxxxx

    Et cela augmente tous les jours.

    Peut-on supprimer ces lignes ? A quoi servent-elles ?
    Ne peuvent-elles pas se supprimer automatiquement ?

    Merci pour vos réponses.

    http://wordpress.org/extend/plugins/baw-post-views-count/

  2. Julio Potier
    Member
    Plugin Author

    Posted 1 year ago #

    Bonjour

    avez vous mis un délai entre le temps de recomptage sans les options ?

    Merci

  3. davidin80
    Member
    Posted 1 year ago #

    Bonjour,

    Je vous remercie pour votre réponse rapide.
    Voici un aperçu du paramétrage : http://data.imagup.com/10/1176474810.jpg

    Est-il possible d'épurer les tables wp_options et wp_postmeta sachant que je ne souhaite garder que le compteur total (où j'ai ajouté le hack pour récupérer le compteur WP-PostViews) et le compteur hebdomadaire ?

    Merci.

  4. Julio Potier
    Member
    Plugin Author

    Posted 1 year ago #

    Oups i forgot to talk in english here (sorry Mika!)

    Ok so, the "900 sec" parameter is guilty, and so am i.

    I'll have a look asap.

    Thanks for your interest!

  5. davidin80
    Member
    Posted 1 year ago #

    Okay!
    I look forward to hearing from you.
    Especially for cleaning the database.

    thank you

  6. davidin80
    Member
    Posted 1 year ago #

    Hi,

    Could you find a solution?
    Thank you.

  7. trevHCS
    Member
    Posted 1 year ago #

    Not sure if the 900 seconds is necessarily the cause as I just discovered this problem on 1 of our 2 popular blogs. Both blogs have identical settings for this plugin and both run on WP 3.5.1 (upgraded from 3.4.x).

    One blog shows nothing when I search the database for the rows mentioned below, but the other had over 80,000 each of these two rows:

    %_transient_timeout_baw_%
    %_transient_baw_count_views-%

    They both have the "Time between counts" set to 0 and all other plugin settings are identical.

    I deleted all those rows from the misbehaving blog, but it's now adding them back slowly again. The other blog is still showing no new rows.

    Only discovered this after the database update for v3.5.1 kept failing and after much searching it was getting stuck reading 161,000 rows from wp_options. :)

    --------

    Regarding cleaning the database as David asked. What I did was this and can't see anything broken yet.

    DELETE FROM  'wp_options' WHERE  'option_name' LIKE  '%_transient_timeout_baw_%'
    
    DELETE FROM  'wp_options' WHERE 'option_name' LIKE  '%_transient_baw_count_views%'

    Trev

  8. trevHCS
    Member
    Posted 1 year ago #

    [Sorry, this was a double post - double clicked the submit button]

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.