• Skip to main content
  • Skip to secondary menu
  • Skip to footer

Market Analysis

Connecting the Dots, Quantifying Technology Trends & Measuring Disruption

  • About
    • Reports
    • How to conduct market analysis
    • How to conduct a stock market analysis
    • What is market scenario?
    • How to do a competitive market analysis
    • Methodology
    • Why is market analysis important?
    • What is economy analysis?
    • How to do a market analysis for a business plan
  • Technology
    • How to do a technology market analysis with focus on disruption factor
    • Venture Capital
      • How to do market analysis for a startup raising funding
  • Domain Marketplace
  • Sponsored Post
  • Contact

Comparing WordPress Performance on MySQL vs SQLite

June 18, 2022

WordPress, an ubiquitous publishing platform run on php and MySQL, powers about 42% of all websites. Now we see two opposite trends in WordPress evolution. Automattic, the company behind WordPress, is pushing WordPress development in the direction of Gutenberg, a block based editor. Automattic’s vision of WordPress’s future is a universal fully-configurable powerful publishing system.

Not everyone is happy with Gutenberg. WordPress has become bloated, complex and slow, the pure joy of simple blogging has gone. The web publishing market has changed, bloggers want simple and fast platforms. Flat file CMS and static site generators are all the rage. Jamstack has become the new standard of web architecture. When using static site generators such as Jekyll, Hugo, Gatsby, Zola and others and Git workflows, the pre-rendered content is served to a CDN network, Cloudflare or Netlify, or directly to AWS S3 (Amazon Cloud Storage). What static sites lack in configurability they make up in speed and speed matters, both for user’s sake and search engine ranking.

While the mainline WordPress is busy with Gutenberg, the new plugins and platforms have emerged turning WordPress to static site generator. In a very recent development Elementor, a popular WordPress-based website builder plugin has acquired Strattic, a static and headless WordPress hosting company.

The time has come to consider evolution of WordPress in the light and fast direction. What are possibilities in this direction?

– Jamstack version of WordPress static site generator
– Either php or Jamstack version of WordPress powered by SQLite.

SQLite is a database engine written in the C language, essentially it’s a single file database that does not require a database server, with a very small footprint making SQLite a perfect choice for embedded systems.

We had experimented a bit to setup and run SQLite-powered WordPress. There is an old plugin SQLite Integration developed by Kojima Toshiyasu. The plugin still works with the latest version of WordPress 6.0. There is also a modification of the same plugin maintained at Github by user “aaemnnosttv” which also works out of the box.

Why to use SQLite instead of MySQL for WordPress?

1. Simplicity of setup, backup and site duplication. All your WordPress files including a single file database are in one folder now. You can copy, FTP or duplicate the entire site without the messy MySQL export/import procedures.

2. Low-cost hosting. You don’t need MySQL-enabled hosting anymore.

3. Higher reliability, low downtime. MySQL is usually located on the separate database server. No more.

4. SQLite is faster than MySQL, probably due lower latency of querying database.

For me personally the site duplication is a game changer. All site settings are stored in database. Setting up a new WordPress site up to a certain standard may take hours. With SQLite it’s just a copy/paste operation plus a few minutes of editing database file.

To conclude: The time is ripe for light stripped-down version of WordPress whether flat file or SQLite-powered.

The following screenshots demonstrate the results of Page Speed tests SQLite vs MySQL:

Page Speed: SQLite, Mobile
SQLite, Mobile
Page Speed: SQLite, Desktop
SQLite, Desktop
Page Speed: MySQL, Mobile
MySQL, Mobile
Page Speed: MySQL, Desktop
MySQL, Desktop

Filed Under: Reports Tagged With: CMS, content management system, Gatsby, Hugo, jamstack, Jekyll, sqlite, static site generators, wordpress, Zola

Footer

Recent Posts

  • The Growing Tin Market: Prospects for Future Demand and Sustainability
  • Prospects for the Growing Lithium Market in the Coming Years
  • DevOps and Agile: Integrating Development and Operations
  • China’s Use of Golden Shares: From Reducing State Role to Quietly Controlling Tech Giants
  • Why Amazon Acquired One Medical: Disrupting the Healthcare Industry with Technology-Enabled Care
  • The End of an Era: Why China is No Longer Viable as the World’s Factory
  • Cloudflare’s FedRAMP authorization opens up a huge market opportunity in the US government sector
  • Datadog’s strong financial results for the fourth quarter and fiscal year 2022 provide a solid case for a Buy recommendation
  • Cisco: Struggling to find new avenues of growth
  • Facing Decline: How Fastly’s Generic CDN Offering and Lagging Innovation Puts It at Risk of Losing to Cloudflare

RSS Market Research Media

  • How plunging birthrates threaten national economies
  • Agile Leadership: Leading Agile Teams for Success
  • Chinese Brands Reach New Heights of Popularity in the West Amid Growing Political Tensions
  • Unrestricted Streaming: How VPNs Can Enhance Media Consumption Experience
  • How the world’s biggest companies have built and defended their moats
  • Virtual Learning Environments: A Game-Changer in Education?
  • Streaming video, training, and gaming coming together to form a cohesive and diverse media and entertainment ecosystem
  • Turn Your Story into a Game: The Art of Gamifying Your Plot
  • The end of cheap money is redrawing the map of corporate earnings
  • The Future of Virtual Reality: How VR is Changing Industries

Media Partners

  • Technology Conferences
  • Event Sharing Network
  • Defense Market
  • Cybersecurity Events
  • Event Calendar
  • Calendarial
  • Opinion
  • Venture Capital
  • Opinion
  • Exclusive Domains

Terms of Service | Privacy Policy | Supplier Disclaimer | Copyright © 2015 MarketAnalysis.com

Technologies, Market Analysis & Market Research Reports

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT