Fragment caching increasing database queries

You are using transient API which works storing data on wp_options table by default. That means that additional database queries will be performed to set the transient and to get the transient. With your code the number of queries should be less for non-logged in users in second and subsequent visits when the transient exists and it is valid.

If you use a persistent cache plugin (or you configure persistent cache at your own) the transient API will use WP_Object_Cache allowing the cached data be stored in memory instead of database, so there won’t be extra database queries.

Summary: using wp_cache functions will store cached data on memory and it is not persistent by default. In the other hand, transient API is persistent always and it use database by default. If you configure persistent cache, transient API and WP_Object_Cache return same results as transient API will use WP_Object_Cache.

Related Posts:

  1. Should I use Transient API to store HTML String, or Object?
  2. Using a wildcard with delete_transient()
  3. How to purge all transient caches?
  4. Transient / object cache maximum key length [duplicate]
  5. How to purge all transient caches?
  6. Transients are not expiring as expected in simple custom plugin
  7. How to store or cache custom shopping cart data for every user’s session
  8. How to decode wordpress transient cache stored in database?
  9. Hook an action when a transient is deleted ? Can’t get it to work!
  10. After having installed APC Object Cache Backend transients stopped working
  11. Should I use transients for these API call results?
  12. How to create a transient that persists the data for the whole duration of the expiration, even when object cache is enabled?
  13. W3 total cache – cache refresh programmatically [closed]
  14. How does object caching work?
  15. Caching: APC vs APCu vs OPcache
  16. Best way to show Dynamic Content on a Cached WordPress Site?
  17. Is define(‘WP_CACHE’, true) needed for object caching?
  18. Prevent WordPress from sending Cache-control http header
  19. Optimize apache for WP use
  20. Is get_option() faster than accessing get_transient()?
  21. Cache remote (HTTP) request with Transients API
  22. Is there any danger in deleting all transients?
  23. Pros and Cons for high “expire time” on wp-super-cache or w3-total-cache? [closed]
  24. Limit cache size from W3 Total Cache [closed]
  25. Best practices for using the transients API
  26. Does a query executed through wpdb class get cached?
  27. Using transients in conjunction with memcached
  28. Configuring WordPress for Amazon CloudFront Caching?
  29. Caching: Force fresh content for logged-in users (potentially by adding a query variable to the URL)
  30. Multiple WordPress sites eat up alot of RAM
  31. What exactly is an advanced object cache?
  32. Storing posts social counters by using transient api
  33. Will I see a performance hit if I use native API calls like get_the_title() instead of $post->post_title?
  34. WordPress Browser Cache with W3-Total-Cache doesn’t show new posts [closed]
  35. Nginx + WordPress + HHVM: Why isn’t Batcache working? Would Varnish help even more?
  36. Does a low traffic WordPress site need a caching plugin and a CDN
  37. Automatically Refresh WordPress Stylesheet
  38. wp_cache_set() or wp_cache_add()
  39. How to use cache with simplepie
  40. Can I force get_option to go back to the DB instead of cache?
  41. WordPress transients for a shortcode
  42. Which WordPress pages/URLs should never be cached?
  43. How to archive a wordpress site (make it read only)
  44. Stale cache handling with a persistent object cache
  45. Is priming a Transient Cache possible?
  46. Varnish + W3 Total Page Cache [closed]
  47. Are there any server requirements for WordPress transients to work properly?
  48. Should the caching of WordPress menus be specific to each page?
  49. Writing a cache manifest file for a WordPress blog (app cache, offline web applications)
  50. Transients vs CRON +Custom Fields: Caching Data Per Post
  51. Transient not working for custom loops
  52. W3 Total Cache doesn’t detect memcached [closed]
  53. Settings to get the most out of W3 Total Cache
  54. How to force content refresh of a page that has been loaded previously by the user? [closed]
  55. Help Pinpointing Source of Caching Issue
  56. How to clear cache without a plugin [closed]
  57. can’t see live version of style.css – is it web server caching?
  58. Want to enforce the visitor to load the new version of your stylesheets and scripts [closed]
  59. Can someone explain WordPress caching, and what’s the best in my scenario?
  60. Speed up WordPress
  61. wp-super-cache exclude file from caching
  62. wp_transients | wp_object_cache VS SESSIONS & Cookies?
  63. APC object caching in combination Batcache/memcached page caching?
  64. Transients API and multisite
  65. Should the page cache be refreshed often? [closed]
  66. WordPress caching in development
  67. Plugin a specific cache functionality?
  68. What is difference between ‘Page Cache’ and ‘Object Cache’ in WordPress?
  69. W3 total Cache – Site with query strings
  70. Possible to configure nginx to ignore cache for logged in users in certain roles only?
  71. Check if a user is connected and get is ID without fully loading wordpress
  72. Transient caching for wp query
  73. Should I enable FastCGI on WordPress?
  74. Get the timout value of a saved transient?
  75. Programmatically insert hierarchical terms & set terms for post causes glitch? [duplicate]
  76. Will caching WordPress affect session variables, custom filed updates and displaying images from a non wordpress table?
  77. Getting soft 404 errors (200 status) when caching plugins are enabled
  78. How to totally disable cache in WordPress?
  79. Automatically enabled caching in some hosting companies w/o visible plugin (Must use plugin)
  80. Database Cache and Object Cache Difference?
  81. Register script version not showing
  82. W3 Total Cache plugin integration
  83. Transient API and caching Plugins
  84. How to cache posts based on $_GET? Option name is too long? Options / transients
  85. WordPress Caching – Transients API or “update_user_meta ” Cronjob?
  86. When use a cache system with WordPress
  87. server load. $_SERVER[‘REMOTE_ADDR’] and $_SERVER[‘HTTP_HOST’] [closed]
  88. Optimizing Jetpack for WordPress [closed]
  89. Is it possible to save an entire piece of rendered HTML in a transient?
  90. Execute a piece of code also when the cached version of a page is served
  91. Clearing cached plugin data if it is using an external object cache
  92. Method to make definitively static an abandoned WP blog
  93. How do I fetch feed info from cache instead of directly from feed?
  94. pass-protected pages and posts not protected after enter them 1 time
  95. Can a WordPress blog be entirely hosted on a CDN if cached?
  96. Static HTML page caching for large website [closed]
  97. Transient feeds and caching error
  98. Transient loop issue
  99. To have WordPress interact with memcached it must be installed as a PHP extension?
  100. WordPress caching issue

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)