XF 1.4 Rare, extremely large and slow query after changing a style property

[imthebest]

Hi,

Today I was changing the following style properties:

• General - Configuration - Path to Images
• General - Configuration - Enable Animations, Using Multiplier=0.5
• Header and Navigation - Header Logo Image Path
• Header and Navigation - Facebook Open Graph Logo

And also two phrases:

• new_password
• confirm_new_password

And got the following extremely large and slow query logged (attached).

Is this normal?

Thanks,
Super120

 

[Arty]

Yes, its normal. All style properties are stored as one huge array that includes style properties for all installed styles.

 

[Chris D]

You should absolutely expect large and slow queries to happen at save time. XenForo does as much as possible at save time to ensure things can run as quickly as possible during run time.