Question about database access / static pages

  • I have a single VPS (shared host) which will host perhaps 1000 tiny websites. Each of these websites will be running on WP — and will contain static pages that update very infrequently. Typically a website will have 3 or 4 static pages.

    I need to reduce the I/O to the backend mySQL database to a minimum.

    Will this plugin essentially “shut off” any access to the database and perform only memory or disk I/O after the the initial rendering of a page?

    https://www.ads-software.com/plugins/w3-total-cache/

Viewing 3 replies - 1 through 3 (of 3 total)

  • Are you on a VPS or shared hosting there is a major difference.

    IF you are on shared hosting then you should only be using the Page Caching Enhanced, and Browser Caching.

    HOWEVER if you are on a VPS then you can use other caching modules such as the Database and Object Caching.

    If you are on a VPS run Page Caching Enhanced (from the disk), Browser Caching, and DB Caching with APC. That would save DB queries by running them from Memory.

    Thread Starter chrisv2

    (@chrisv2)

    It is a VPS but this VPS sits on a physical server that hosts other VPS accounts — so it is a shared server, it is *not* a dedicated physical server.

    I need to keep the number of mySQL “open” connection events to a bare minimum. Am I ok using DB caching in this situation or will it cause other problems?

    You could use Database caching, and run it with something like OpCode APC which will run from memory. But if these are single page sites you would be just as good using page cache enhanced.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Question about database access / static pages’ is closed to new replies.