Title: SQLite Cache Author: andreyk Published: Èbìbí 21, 2015 Last modified: Agẹmọ 1, 2016 --- Ṣàwárí àwọn plugin Plugin yìí **kò tíì ṣe àyẹ̀wò pẹ̀lú àwọn ìtújáde mẹ́ta pàtàkì tó kẹ́yìn ti WordPress**. Ó lè jẹ́ pé a kò tọ́jú tàbí ṣe àtìlẹ́yìn fún un mọ́, ó sì lè ní àwọn ọ̀ràn ìbámu nígbà tí a bá lò ó pẹ̀lú àwọn ẹ̀yà WordPress tuntun. ![](https://s.w.org/plugins/geopattern-icon/sqlite-cache.svg) # SQLite Cache Láti ọwọ́ [andreyk](https://profiles.wordpress.org/andreyk/) [Ṣe ìgbàsílẹ̀](https://downloads.wordpress.org/plugin/sqlite-cache.zip) * [Àwọn àlàyé](https://yor.wordpress.org/plugins/sqlite-cache/#description) * [Àwọn àgbéyẹ̀wò](https://yor.wordpress.org/plugins/sqlite-cache/#reviews) * [Ìgbéwọlẹ̀](https://yor.wordpress.org/plugins/sqlite-cache/#installation) * [Ìdàgbàsókè](https://yor.wordpress.org/plugins/sqlite-cache/#developers) [Ìrànlọ́wọ́](https://wordpress.org/support/plugin/sqlite-cache/) ## Àpèjúwe On first request to a given URL whole html code of a page is being stored in the SQLite database. On next requests to the same page WordPress core will not be loaded at all but the content of a page will be retrieved from the the SQLite storage therefore duration of PHP execution decreases in dozen of times. Many sites on the same webserver may use common SQLite storage. Compatible with WordPress Multisite. Requires PHP SQLite PDO. In comparison with plugins generating static html pages this plugin does not create multiple directories and html files but stores all generated pages in one file. Moreover, many wordpress sites on the same webserver may use common SQLite storage. Keeps 404, 301, 302, 304 HTTP statuses, optionally supports ETag, Expires, Content- Length, Content-Type (with charset) headers. #### As the cache script doesnÌtumọ̀ Yorùbá: ’t load the WordPress core where does it save itÌtumọ̀ Yorùbá: ’s settings? To get the plugin working you need to define the SQLite storage location in the` index.php` of the wordpress installation directory (note, not in wp-config.php but index.php). Besides of the SQLite file, this directory contains general settings file (compression setting) and a subfolder for per domain settings. In the admin area (plugin setting page) and to remember after deactivation where the cache located,` litecache_path` WordPress option is used. #### How the plugin handles URLs with and without `www.` prefix? The presence of `www.` prefix is defined in `Settings` Ìtumọ̀ Yorùbá: – `General`. The plugin stores `with_www` parameter in `domains/yourdomain.ini` file in the cache directory and redirects requests correspondingly; these redirects are being processed before cache usage. #### Is it WordPress Multisite compatible? Yes, but for subdomains mode only (blogname.example.com), not for example.com/blogname. A superadmin of a multisite network has access to the first setting form (cache location), blog admins have access to the second form and purge form. ## Ìgbéwọlẹ̀ * Upload the plugin from the WordPress plugin installation page or unpack `sqlite- cache` folder to the plugins directory (usually `wp-content/plugins/`). * Activate the plugin through the WordPress Plugins manager, then you will see` SQLite Cache` item in the `Settings` submenu of WordPress admin menu. * Forms on the the plugin settings page: 1. Define a directory where the plugin settings and the cache storage will be located. 2. Define cache expiration time and HTTP headers the cached pages will be delivered with. 3. Third form is for cleaning cache. Note the cache will be cleared every time when you submit the domain settings form so you donÌtumọ̀ Yorùbá: ’t need to clear cache after changing settings. * Add two lines into `index.php` file (you will be notified on the settings page) to define where the cache storage is located and include the cache engine file. Done! For testing, enable `Show performance time` checkbox to ensure the cache engine works. ## FAQ IÌtumọ̀ Yorùbá: ’m the owner of a site and I see `Edit page` link near the page content. Will it be cached? No. The cache engine is not used for authorized users, for those who has commenter cookie and for visitors with active PHP sessions. What IÌtumọ̀ Yorùbá: ’ll see after posting a comment? The result of a page after POST request method will isnÌtumọ̀ Yorùbá: ’t being cached so you will see your comment or a notification about pending comment. Also, see the previous question. What else is not cached? * Any URL containing `wp-`, `.php`, `/files/` and `blogs.dir`. * Results of POST and HEAD request methods. Do I need clear cache when I edit an existing post or page or add a comment? Cache entry of a single post page or page will be cleared automatically after post/ page update or publishing a comment. Also, the blog list page cache is cleared on post updates. You need to purge cache after modifying menus, widgets, switching theme, changes of theme options. Can I disable cache for some pages? Yes, you can define a list of URL patterns to exclude them from cache. Does the `Contact Form 7` work on cached pages? Yes, it works by itself but additional functionalities such as CAPTHCHAs might be not working. How the plugin handles with 404 Not Found response and redirects? The plugin caches `404 Not Found` HTTP status code with the same expiration period as other pages as well as redirect codes 301 and 302 with Location header. How to deactivate the plugin? Click on Deactivate link on the plugins list, then the settings file (yourdomain. ini) will be deleted so cache engine will not be applied for the current domain. However it stays working for other sites installed in the same directory until it is included in the `index.php` and their setting files exist. ## Àwọn àgbéyẹ̀wò ![](https://secure.gravatar.com/avatar/098d7931cde7313738b15b33c34fa8bcc606b049aafd712de205c50ba2f7a890? s=60&d=retro&r=g) ### 󠀁[glitchy](https://wordpress.org/support/topic/glitchy-2/)󠁿 [frazzledjazz](https://profiles.wordpress.org/frazzledjazz/) Ọwẹ́wẹ̀ 3, 2016 it works but its glitchy.cant update menu when using this enabled. add legull custom link and you will see what i mean. [ Ka gbogbo àwọn àgbéyẹ̀wò 2 ](https://wordpress.org/support/plugin/sqlite-cache/reviews/) ## Àwọn Olùkópa & Olùgbéejáde “SQLite Cache” jẹ́ ètò ìṣàmúlò orísun ṣíṣí sílẹ̀. Àwọn ènìyàn wọ̀nyí ti ṣe ìkópa sí plugin yìí. Àwọn Olùkópa * [ andreyk ](https://profiles.wordpress.org/andreyk/) [Túmọ̀ “SQLite Cache” sí èdè rẹ.](https://translate.wordpress.org/projects/wp-plugins/sqlite-cache) ### Ṣe o nífẹ̀ẹ́ sí ìdàgbàsókè? [Ṣàwárí koodu](https://plugins.trac.wordpress.org/browser/sqlite-cache/), ṣàyẹ̀wò [ibi ìpamọ́ SVN](https://plugins.svn.wordpress.org/sqlite-cache/), tàbí ṣe àgbékalẹ̀ sí [àkọsílẹ̀ ìdàgbàsókè](https://plugins.trac.wordpress.org/log/sqlite-cache/) nípasẹ̀ [RSS](https://plugins.trac.wordpress.org/log/sqlite-cache/?limit=100&mode=stop_on_copy&format=rss). ## Àkọsílẹ̀ àwọn àyípadà 0.6.2 * Fix Content-Length header value. * Fix php warning when $_SERVER[‘HTTPS’] is not set. 0.6.1 * Improved usability on multisite: get_site_option instead of get_option (update, delete). * Cleaning code (check input before gzcompress/uncompress, bug fix in ob_start). * Ukrainian translation. 0.6 First public version. ## Àkójọpọ̀ Meta * Ẹ̀yà **0.6.2** * Ìgbàgbọ́hùn tó kẹ́yìn **ọdún 10 sẹ́yìn** * Àwọn ìgbéwọlẹ̀ tó ṣiṣẹ́ **10+** * Ẹ̀yà WordPress ** 3.8.1 tàbí ju bẹ́ẹ̀ lọ ** * Dánwò dé **4.5.33** * Èdè * [English (US)](https://wordpress.org/plugins/sqlite-cache/) * Àwọn àmì * [cache](https://yor.wordpress.org/plugins/tags/cache/)[performance](https://yor.wordpress.org/plugins/tags/performance/) [SQLite](https://yor.wordpress.org/plugins/tags/sqlite/) * [Ìwòye Tó Péye](https://yor.wordpress.org/plugins/sqlite-cache/advanced/) ## Àwọn ìbò 4 lára àwọn ìràwọ̀ 5. * [ 1 5-star review ](https://wordpress.org/support/plugin/sqlite-cache/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/sqlite-cache/reviews/?filter=4) * [ 1 3-star review ](https://wordpress.org/support/plugin/sqlite-cache/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/sqlite-cache/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/sqlite-cache/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/sqlite-cache/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/sqlite-cache/reviews/) ## Àwọn Olùkópa * [ andreyk ](https://profiles.wordpress.org/andreyk/) ## Ìrànlọ́wọ́ Nǹkan wà tí o fẹ́ sọ? Ṣé o nílò ìrànlọ́wọ́? [Wo àpéjọ ìrànlọ́wọ́](https://wordpress.org/support/plugin/sqlite-cache/)