Improve performance by removing unnecessary database queries

Options are persistent. You can set them when you activate your theme and then just use them. There’s no need to change them when rendering any particular page unless your logic actually changes them.

And doing so may cause confusion. For example, lots of changes to image and thumbnail default sizes will make your Media subsystem contain lots of generated thumbnails with sizes you don’t use any more.

Finally, consider using a persistent object cache. It significantly reduces database traffic for options and transients. Read all about it. https://developer.wordpress.org/reference/classes/wp_object_cache/#persistent-caching

Related Posts:

  1. How to solve slow WordPress site caused by attachment_metadata
  2. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  3. WordPress database scalability from the code perspective
  4. WordPress for a very large website
  5. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  6. Database slowdown after update to 3.4.1
  7. Which is more efficient? Using usermeta, or creating a new MySQL table?
  8. fastest replacement DB
  9. How to prevent/delay MySQL connections when an object cache is used?
  10. Optimizing function that automatically creates internal links based on post title string
  11. Mysql Queries per Visit – Crazy High
  12. Rename a table in MySQL
  13. How should I tackle –secure-file-priv in MySQL?
  14. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  15. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  16. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  17. MySQL SELECT increment counter
  18. phpMyAdmin – Error > Incorrect format parameter?
  19. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  20. Using wpdb to connect to a separate database
  21. MySQL Database User: Which Privileges are needed?
  22. Why is my database import losing text widget data?
  23. Will it break my site if I delete all transient records in wp_options table?
  24. Checking if Database Table exists
  25. Please explain how WordPress works with MySQL character set and collation at a low level
  26. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  27. How to fetch Data in WordPress using MySQLi or $wpdb
  28. WordPress Database lost auto increment
  29. Connect to database using wordpress wp-config file
  30. What’s a good strategy for planning WordPress DB growth?
  31. wpdb->insert multiple record at once
  32. Reset Post IDs to less than 64bit integer
  33. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  34. Restoring WordPress posts from database only
  35. How to define composite keys with dbDelta()
  36. Is it possible to define two databases for one installation?
  37. Does WordPress use the InnoDB engine for MySQL by default?
  38. Slow wp_term_relationships query
  39. How to use “TRUNCATE TABLE” MySQL statement?
  40. Can I use MariaDB instead of MySQL in wordpress?
  41. Performance tips for a large user base [closed]
  42. Slow SQL_CALC_FOUND_ROWS Query
  43. WP_Options ID high
  44. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  45. What are conventions about the schema of the $table_prefix
  46. Split WP install between 2 databases?
  47. WordPress database becoming huge. How to analyze and optimize it? fear of running out of memory
  48. Inserting Post Meta From SQL
  49. Improve or optimize a very slow query
  50. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  51. Why does dbDelta() not catch MysqlErrors?
  52. Efficiency on displaying random authors based on large database
  53. Is deleting orphaned wp_options entries safe?
  54. Is altering a default WordPress database table update safe?
  55. Huge wp_options table
  56. “MySQL server has gone away” since update to 3.8
  57. Delete all post meta except featured image
  58. Custom DB_COLLATE (collation) value not working on fresh install?
  59. What causes the “max_user_connections” warning on WordPress frontend?
  60. what to do when your WordPress database is too large?
  61. Change all http to https in mysql databse?
  62. WooCommerce – Query for ordered products
  63. Large database causes slow load
  64. Relationship between performance and database size
  65. Changing BIGINT to INT
  66. Error establishing a database connection – with Debug Data
  67. How to execute mulitple statement SQL queries using $wpdb->query?
  68. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  69. Can I transfer a mysql database to another site?
  70. WordPress and automated MySQL backups to a different host
  71. Database with mixed collation (utf8mb4 & utf8_general_ci)
  72. Query WordPress database by registered date and role
  73. MySQL Syntax Error upon restoring database from backup [closed]
  74. Tons of Twitter rows in my database
  75. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  76. How to insert data into MySQL database from the form created in WordPress site
  77. Set Display Name to first and last name (phpmyadmin SQL Query)
  78. Size article thumbnails and retrieve them directly from database
  79. WordPress site uses MyISAM, should I switch to InnoDB necessary?
  80. Is it safe to convert tables from MyISAM to InnoDB?
  81. Emojis getting converted to “?”
  82. wp_redirection_404 table has grown to 7GB
  83. Migrating database / content of non-CMS site to WordPress
  84. Does WordPress ever need multiple databases?
  85. Why are no posts showing despite my apparently correct DB restoration?
  86. Should I remove transients from the wp_options table?
  87. Select Multiple meta_value from WP DB; Single Query
  88. Delete all post meta except featured image Using SQL
  89. How do I properly update the WordPress database password?
  90. wpdb_prepare with multiple or condition
  91. One post carries 30 postmeta values, is this too much?
  92. Is it possible to split database tables using HyperDB?
  93. Adding new row to wp_post table
  94. Improve wp query perfomance on large db
  95. WordPress Install and Database on separate hosting?
  96. What happens if I overwrite the current wp_options table with a backup from a week ago?
  97. WordPress mysql table double prefixes
  98. SQL Error wp_commentmeta – incorrect table definition
  99. WordPress database error – Error in SQL syntax – I can’t identify any error?
  100. CRUD operations using WordPress database API
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)