Wordpress Themes - WP Forum at BFA
Click here to register or to donate.
Auto self-registration is not available here - far too many spammers. This forum has many, many backlinks and because of that there is an intense desire among spammers to drop their links here.

Wordpress Themes - WP Forum at BFA » WordPress Themes » Atahualpa 3 Wordpress theme » New Versions, & Updating »

Database performance issue with 3.7.23


  #1  
Old Mar 21, 2015, 08:23 AM
foschizzle
 
2 posts · Dec 2013
I've noticed that Atahualpa performs a ~20k SQL update of wp_options where name='bfa_ata4' on a large percentage of uncached page views. This causes a large amount of unnecessary Mysql write activity and can be a large drain on performance - impacting not just the page view but the entire server.

It appears to just be making the same change back and forth:

h_blogtitle;i:1 to h_blogtitle;i,2 and h_posttitle;i:1 to h_posttitle;i:2

the next update then reverses it.

It would seem that it may be the code in bfa_get_options.php around line 506:

if ( $bfa_ata['h1_on_single_pages'] == "Yes" AND ( is_single() OR is_page() ) ) {
$bfa_ata['h_blogtitle'] = 2; $bfa_ata['h_posttitle'] = 1;
} else {
$bfa_ata['h_blogtitle'] = 1; $bfa_ata['h_posttitle'] = 2;
}


Thanks for looking at this.
  #2  
Old Mar 21, 2015, 12:27 PM
juggledad's Avatar
juggledad
 
23,576 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
How did you determine it was doing an MySQL update?

As far as I know, the only time an update to wp-options table is done is in the backend when you hit the save button.

Now, you will see a get each time a page is requested to get the one row in the database (the 'bfa_ata4' row) which contains all the options. The code you are pointing to has not changed since at least 3.7.15 and probably earlier. That code is just flipping the values of two variables in an array. No MySql call at all.
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Atahualpa performance optimization using w3 cache and CDN networks everyman Plugins & Atahualpa 6 Oct 28, 2012 01:50 AM
DUK's Performance Tuning Guide for Atahualpa Duk Atahualpa 3 Wordpress theme 4 Feb 6, 2012 06:08 AM
[SOLVED] Atahualpa performance versus Thesis, with Yslow, is Atahualpa too "heavy"? everyman Header configuration & styling 8 Apr 21, 2011 07:41 AM
qTranslate performance problems DSmidgy Atahualpa 3 Wordpress theme 8 Apr 5, 2010 05:33 PM


All times are GMT -6. The time now is 03:47 AM.


Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.