[Plugin: Recent Google Searches Widget] Extreme slow mysql queries

  • facing extreme slow queries like this. can any one tell me what is this?

    # Thu Mar 24 15:36:49 2011
# Query_time: 19.317359  Lock_time: 0.000131 Rows_sent: 0  Rows_examined: 1
use *****_DB;
UPDATE <code>wp_options</code> SET <code>option_value</code> = 'a:5:{i:0;b:0;s:5:\"title\";s:15:\"Recent Searches\";s:8:\"maxlinks\";i:15;s:12:\"rgs_nofollow\";s:1:\"N\";s:7:\"history\";a:15:{s:32:\"iphone battery price in pakistan\";i:1301002590;s:36:\"samsung galaxy arc price in pakistan\";i:1301002492;s:18:\"Qualcomm MSM7227 1\";i:1301002128;s:27:\"htc salsa price in pakistan\";i:1301001281;s:24:\"nokia latest mobile 2011\";i:1301000960;s:34:\"samsung galaxy 2 price in pakistan\";i:1301000790;s:37:\"samsung galaxy mini price in pakistan\";i:1300999250;s:28:\"iphone 3g price pakistan2011\";i:1300998980;s:4:\"e 72\";i:1300998538;s:19:\"symbian mobile sets\";i:1300998111;s:30:\"bold 3 9780 prices in pakistan\";i:1300997876;s:19:\"galaxy ace pakistan\";i:1300997201;s:24:\"samsung android pakistan\";i:1300996678;s:41:\"nokia e72 white edition price in pakistan\";i:1300995871;s:41:\"motorola droid 2 global price in pakistan\";i:1300995596;}}' WHERE <code>option_name</code> = 'widget_kpg_rgs'

    https://www.ads-software.com/extend/plugins/recent-google-searches-widget/

Viewing 1 replies (of 1 total)
  • Plugin Author Keith P. Graham

    (@kpgraham)

    This is updating the wp_options table for the plugin data. This occurs every time there is a user arriving from a search engine. The plugin keeps track of search words that the search engines are using to find the site. The table update will only occur when a user comes in through Google, Bing or Yahoo search engine.

    Updating the WP_OPTIONS table should be quick. The length of the text field used for the option value should never be over long.

    This is all done through standard WP API calls so there is no SQL to optimize.

    You can double check this by disabling the plugin and running your profiles again. If the plugin is at fault there will be no additional problems. If the plugin has nothing to do with it, you will see the profile pointing the finger at other queries.

    You should also download and install WP_Optimize plugin to compress and optimize the db. The results aren’t dramatic, but you should see some small increase in speed.

Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: Recent Google Searches Widget] Extreme slow mysql queries’ is closed to new replies.