Join the Soledad Facebook Users Group here
for Share, assistance, discussion, and Updates related to Soledad WordPress Theme.

If you can't create a new ticket - you can send us an email via our contact form and we will get back to you.

Okay
  Public Ticket #2201032
WEbsite Slow
Closed

Comments

  • Agenparl started the conversation
    October 31, 2019 at 8:36am

    Hi, i have a lot of request in my sql db like this:

    UPDATE wp_postmeta SET meta_value = '0' WHERE meta_key = '_count-views_week';

    Is possible to disable view count and update?

  • Agenparl replied
    October 31, 2019 at 9:11am

    If you need 

    Account:

    https://agenparl.eu/wp-admin

    pencidesign

    pencidesign2019!

    Ftp:

    ftp.agenparl.eu port 21 user

    pencidesign

    pencidesign2019!

  •  501
    Penci replied
    November 1, 2019 at 2:43am

    Hi,

    Do you want disable  post count view  on your site.

    Best Regards,

    PenciDesign

  • Agenparl replied
    November 1, 2019 at 1:01pm

    Yeah! i've a busy website with a lot of posts...and need to complete disable post count view

  •  501
    Penci replied
    November 2, 2019 at 2:28am

    Hi,

    Please go to Custiomizer > General Options then scrolldown and check  "Hide Post Count Views" option as screenshot http://prntscr.com/prdm6x


    Best Regards,

    PenciDesign

  • Agenparl replied
    November 2, 2019 at 5:12pm

    Yeah the count views was hided but not disabled. My slowest query reguarding the count view. Can i disable it totally?  the post view count still in background! 

  •  501
    Penci replied
    November 3, 2019 at 5:06pm

    Hi,

    I disable post count view on your site .

    I use "Query Monitor" plugin to check  and i don't see query come from post count view.

    Please check it again and tell me about tool you check query.


    Best Regards,

    PenciDesign

  • Agenparl replied
    November 3, 2019 at 9:43pm

    Time                 Id Command    Argument
    # Time: 191027  3:32:47
    # User@Host: agenparl_wp2019[agenparl_wp2019] @ localhost []  Id: 485881
    # Query_time: 40.499701  Lock_time: 0.000031 Rows_sent: 0  Rows_examined: 132194
    use agenparl_agenparl2019;
    SET timestamp=1572143567;
    UPDATE wp_postmeta SET meta_value = '0' WHERE meta_key = '_count-views_week';
    # User@Host: agenparl_wp2019[agenparl_wp2019] @ localhost []  Id: 485922
    # Query_time: 22.820718  Lock_time: 17.724347 Rows_sent: 0  Rows_examined: 11
    SET timestamp=1572143567;
    UPDATE `wp_postmeta` SET `meta_value` = '32' WHERE `post_id` = 798730 AND `meta_key` = '_count-views_all';
    # User@Host: agenparl_wp2019[agenparl_wp2019] @ localhost []  Id: 485937
    # Query_time: 10.744701  Lock_time: 5.648295 Rows_sent: 0  Rows_examined: 9
    SET timestamp=1572143567;
    UPDATE `wp_postmeta` SET `meta_value` = '17' WHERE `post_id` = 803631 AND `meta_key` = '_count-views_all';
    # Time: 191027  3:33:22
    # User@Host: agenparl_wp2019[agenparl_wp2019] @ localhost []  Id: 485973
    # Query_time: 18.452750  Lock_time: 0.000031 Rows_sent: 0  Rows_examined: 132194
    SET timestamp=1572143602;
    UPDATE wp_postmeta SET meta_value = '0' WHERE meta_key = '_count-views_week';
    # Time: 191027  3:33:49
    # User@Host: agenparl_wp2019[agenparl_wp2019] @ localhost []  Id: 486036
    # Query_time: 3.191662  Lock_time: 0.000094 Rows_sent: 0  Rows_examined: 130039
    SET timestamp=1572143629;


    This is the slowest query on my mysql server, this log come from my server provider....

  •  501
    Penci replied
    November 4, 2019 at 3:00pm

    Hi,

    I disable post count view module on your site.

    use "Query Monitor" plugin to check and don't see '_count-views_week' meta working.

    Please remove cache, debug log and re-check it again 


    Best Regards,

    PenciDesign