• Airic

    (@airic)


    Hi,

    I used to use this plugin for months now but, since a few weeks, I have an issue with page speed. For some reason it is not working as it used to I have no clue on how to solve this. Here is what I get from my logs:
    _______________________________________________________________

    964101 wpnccontc       localhost wpnccontco         10  Sleep                                                                                                                                                                       
       964160 wpnccontc       localhost wpnccontco          9  Query  Sending SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'                                                                                      
       964161 wpnccontc       localhost wpnccontco          7  Query  Sending SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'                                                                                      
       964060 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_checkbox_label' LIMIT 1                                                          
       964073 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_checkbox_label' LIMIT 1                                                          
       964079 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964106 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964124 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964132 wpnccontc       localhost wpnccontco          2  Query  Waiting INSERT INTO <code>wp_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_doing_cron', '1556025168.2624630928039550781250', 'yes') ON DUPLICAT
       964135 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964137 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_notify_authors' LIMIT 1                                                          
       964138 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_manager_page' LIMIT 1                                                            
       964139 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_manager_page' LIMIT 1                                                            
       964140 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_manager_page' LIMIT 1                                                            
       964141 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964146 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964148 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_manager_page' LIMIT 1                                                            
       964149 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_notify_authors' LIMIT 1                                                          
       964151 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_manager_page' LIMIT 1                                                            
       964152 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_manager_page' LIMIT 1                                                            
       964153 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_show_subscription_box' LIMIT 1                                                   
       964154 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_show_subscription_box' LIMIT 1                                                   
       964155 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_show_subscription_box' LIMIT 1                                                   
       964157 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_show_subscription_box' LIMIT 1                                                   
       964158 wpnccontc       localhost wpnccontco          2  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'subscribe_reloaded_show_subscription_box' LIMIT 1                                                   
       964162 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964163 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964164 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964165 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964166 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964167 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964168 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964169 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964170 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964171 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964172 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964173 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964174 wpnccontc       localhost wpnccontco          2  Sleep                                                                                                                                                                       
       964077 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'advanced-ads-responsive-license-expires' LIMIT 1                                                    
       964107 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'advanced-ads-responsive-license-expires' LIMIT 1                                                    
       964110 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'advanced-ads-responsive-license-expires' LIMIT 1                                                    
       964111 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'cli_pg_content_data' LIMIT 1                                                                        
       964112 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'cli_pg_content_data' LIMIT 1                                                                        
       964113 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'cli_pg_content_data' LIMIT 1                                                                        
       964114 wpnccontc       localhost wpnccontco          1  Sleep                                                                                                                                                                       
       964116 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'cli_pg_content_data' LIMIT 1                                                                        
       964118 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'cli_pg_content_data' LIMIT 1                                                                        
       964119 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'cli_pg_content_data' LIMIT 1                                                                        
       964120 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'cli_pg_content_data' LIMIT 1                                                                        
       964121 wpnccontc       localhost wpnccontco          1  Sleep                                                                                                                                                                       
       964122 wpnccontc       localhost wpnccontco          1  Sleep                                                                                                                                                                       
       964125 wpnccontc       localhost wpnccontco          1  Query  Waiting SELECT option_value FROM wp_options WHERE option_name = 'cli_pg_content_data' LIMIT 1   

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author WPKube

    (@wpkube)

    Hi,

    Can you let me know how many subscribers you have, I’ll replicate on my installation to have the same amount and run some tests.

    Thread Starter Airic

    (@airic)

    Could you let me know how to find out ?

    Thread Starter Airic

    (@airic)

    Well, if it helps I can have access to “only” 1 000 articles in the SCTR option page and I have around 30 000 subscribers on my website…

    regards

    Plugin Author WPKube

    (@wpkube)

    Hi,

    Yeah, the table is limited to 1000 entries. There’s an update coming today or tomorrow, will add info on total amount of subscribers in WP admin > StCR > StCR System so we can know how much you have in total so we can test it out and figure out how to optimize it.

    Thread Starter Airic

    (@airic)

    OK, I ll wait then.

    Regards

    Plugin Author WPKube

    (@wpkube)

    Hi,

    The new version is released. After you update head over to WP admin > StCR > StCR System. At the top you’ll see the info on the amount of subscribers and amount of subscriptions. Let me know what the numbers are.

    Thread Starter Airic

    (@airic)

    here you go…

    Subscribers Count
    793 subscribers with 1324 subscriptions

    Regards

    Plugin Author WPKube

    (@wpkube)

    Oh, was expecting it to be more. Got a bit over 10000 on my test installation.

    Will release another update today that will place some more info on that system page. That info will show how much time it’s taking to make specific database queries that the plugin does. So that will shows us which ones take long to execute.

    Plugin Author WPKube

    (@wpkube)

    Also, can you let me know where is the slowing down most notable. Is the whole website affected or specific post/pages or actions?

    Knowing the specifics helps to figure out where to look for the issue.

    The logs you sent originally are just simple queries for getting a value of a setting field. Those are called by the WordPress get_option field. The log shows it for our plugin, for Advanced Ads plugin and Cookie Consent plugin.

    The actual slowdown would be happening in other areas, where a large amount of data is being retrieved from the database.

    Also, there’s a really handy plugin Query Monitor. If you activate it you’ll be able to check what exact queries are being made on any page and how long they took. So you simply order them by the time (how long they took to execute) and see which ones took the longest. That info would be of great help, do you think that’s something you could try?

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Slowing down a lot’ is closed to new replies.