Is there a limit to size of data stored in update_option()?

The option_value column in the database is LONGTEXT, meaning it can hold up to 4GB of text.

But keep in mind that WordPress loads all options on every page load by default, and storing large values for options you only intend to use on a single page is inefficient. Either set the autoload argument of update_option() and add_option() to false, or store the data in a custom table and only query it when you need it.

Related Posts:

  1. Can I force get_option to go back to the DB instead of cache?
  2. FATAL ERROR – white page – no site showing
  3. How does object caching work?
  4. Is define(‘WP_CACHE’, true) needed for object caching?
  5. Is get_option() faster than accessing get_transient()?
  6. Pros and Cons for high “expire time” on wp-super-cache or w3-total-cache? [closed]
  7. Limit cache size from W3 Total Cache [closed]
  8. Configuring WordPress for Amazon CloudFront Caching?
  9. WordPress Browser Cache with W3-Total-Cache doesn’t show new posts [closed]
  10. Nginx + WordPress + HHVM: Why isn’t Batcache working? Would Varnish help even more?
  11. Does a low traffic WordPress site need a caching plugin and a CDN
  12. Automatically Refresh WordPress Stylesheet
  13. wp_cache_set() or wp_cache_add()
  14. How to use cache with simplepie
  15. Fragment caching increasing database queries
  16. Which WordPress pages/URLs should never be cached?
  17. How to archive a wordpress site (make it read only)
  18. Stale cache handling with a persistent object cache
  19. Varnish + W3 Total Page Cache [closed]
  20. Are there any server requirements for WordPress transients to work properly?
  21. W3 Total Cache doesn’t detect memcached [closed]
  22. Settings to get the most out of W3 Total Cache
  23. can’t see live version of style.css – is it web server caching?
  24. Speed up WordPress
  25. wp-super-cache exclude file from caching
  26. Should the page cache be refreshed often? [closed]
  27. Plugin a specific cache functionality?
  28. Possible to configure nginx to ignore cache for logged in users in certain roles only?
  29. Check if a user is connected and get is ID without fully loading wordpress
  30. Should I enable FastCGI on WordPress?
  31. Will caching WordPress affect session variables, custom filed updates and displaying images from a non wordpress table?
  32. Register script version not showing
  33. When use a cache system with WordPress
  34. Optimizing Jetpack for WordPress [closed]
  35. Is it possible to save an entire piece of rendered HTML in a transient?
  36. Transients are not expiring as expected in simple custom plugin
  37. Prevent installation of style.css cookies and file caching
  38. How can I revert to showing cached pages when no database connection is available? [closed]
  39. How to speed up my site [duplicate]
  40. Headway body classes and W3TC page cache conflict [closed]
  41. How can I cache the LearnDash quizzes on my server?
  42. WP_Object_Cache for heavy WP_Query
  43. How to decode wordpress transient cache stored in database?
  44. WordPress PHP 5.5 and OPcache
  45. Batcache messages no longer in page source
  46. After having installed APC Object Cache Backend transients stopped working
  47. How to make page/post password protected so you must reenter everytime you visit the page?
  48. Fixed version number for cached stylesheets and javascript
  49. Are get_bloginfo queries cached to start, or should they be cached?
  50. Is it duplicated if I cache an object that uses data from postmeta?
  51. How effective are cacheing plugins for dynamic pages?
  52. How can I permanently cache or “archive” a WP blog without needing future maintenance
  53. How does WP’s cache maintain persistence through page reloads?
  54. Any idea why Google not caching my site? [closed]
  55. Combile External JS files using W3 Total Cache [closed]
  56. Gravity forms / Recaptcha / Autoptimize – somewhere it goes wrong
  57. How to solve minify js and css first time load delay?
  58. How to get Caching Plug-ins to work on localhost with HTTPS?
  59. WordPress website not showing changes without clearing cache
  60. Cloud flare, cache, minify question [closed]
  61. How can I cache font files on WordPress [closed]
  62. W3 total – leverage browser caching not working with cdn delivered images [closed]
  63. Cache WordPress for offline use
  64. issues with object cache (memcached as backend) and wpmu when flush_all is run
  65. Scheduling doesn’t work due to caching?
  66. APC fragmention woes on Apache AWS EC2 Small instance with WordPress and W3TC [closed]
  67. How to get the URL of a sitemap that contains a certain post?
  68. Best practices for the cache of a static WordPress site, including CDN Cache and Cache Plugin
  69. Site’s first loading on a new browser with no cache is messed up
  70. How to not cache nonces with WP Rocket?
  71. Site speed slows when user logged in
  72. Password Protected Pages Don’t Accept A Valid Password After Changing The Password
  73. Clear cache when comment is added
  74. Way to prevent snippet of template from being cached?
  75. How to make login / logout links cache independent?
  76. Non Admins Getting Cached Posts
  77. Why WordPress cache is not available after reload page?
  78. WordPress on mobile devices with new data after updating page
  79. New blog posts don’t update on page – How to force update of cookies more frequently?
  80. Having issues fixing site speed
  81. Is there a way to cache WordPress that does not loads core?
  82. Need to refresh page after each change
  83. leverage browser caching in wordpress
  84. PHP Fatal Error in cache.php on line 123 $wp_object_cache is non-object
  85. No Query String vs Ignore Query String in WordPress
  86. w3 total cache uninstall remove cache
  87. Completely reload style.css
  88. Page wrongly displayed when cache plugin activated
  89. GravatarLocalCache Plugin Broken in WordPress 4.2
  90. Serve content from centralized location
  91. My website resets when accessing the index page
  92. Major cache but only on WordPress site
  93. Debug Performance Issues
  94. User cannot authenticate after signup when object cache enabled
  95. what is the cache directory for in my theme? (version control it?)
  96. WP 3.5 caching problem
  97. Convert WordPress to static website by using the pages generated by the caching plugin?
  98. Cannot add version of main.css to wordpress on testing enviroment
  99. How to create a transient that persists the data for the whole duration of the expiration, even when object cache is enabled?
  100. Why does enabling caching break password protected pages? Is there a way around this?
techhipbettruvabetnorabahisbahis forumutaraftarium24edusedueduseduseduedueduseduseduedus