Check speed comparison

  • Resolved criserjjio

    (@criserjjio)


    10 months ago

    Hello
    We installed and configured the Index WP MySQL For Speed plugin on our dev site to see if it would speed up our postcode search which involves searching post types
    On that page, you can try adding this postcode to run the postcode search
    NW5 2XD

    We tested and compared both sites (live and staging) https://www.fair-well.co.uk/delivery/ and the staging https://dev.erjjiostudios.com/fair-well-db/delivery/ but seems they still have the same loading time even if the staging already has the index keys

    Can you help us more about it?

    Thanks in advance!

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author OllieJones

    (@olliejones)

    I’m happy to try to help you. I need to take a look at your problem in detail to do that. Do you use a particular plugin to do your offendingly slow postcode search? If so, which one? Can you give me a pointer to its source code?

    And, I need you to gather some information following these instructions.

    You’ll use the plugin to upload your site metadata — and reply to this topic to tell me the upload id.

    Then you’ll start capturing a monitor (again using the plugin). While the monitor is active, please do a few of those postcode searches.

    Then upload the monitor. Hopefully the metadata and monitor uploads will let me identify a slow-database-query issue.

    Thread Starter criserjjio

    (@criserjjio)

    Hi thank you for getting back ??
    For the search, here are the Plugins we are using:
    1. Gravity Form
    2. Toolset
    – Toolset Views
    – Toolset Maps
    3. Beaver Builder
    – Conditional output based on the following:
    – if the user is logged in or logged out
    – If the Woocommerce cart is empty or not
    – if the postcode is allowed or not

    The process for this feature or function is to look for Nearby bookings based on the Postcode they provided, the postcodes are made using custom taxonomies

    Plugin upload ID: c3ryWC8s
    Monitor data uploaded

    Plugin Author OllieJones

    (@olliejones)

    Thanks for the uploads. I don’t see any obvious performance problems in the queries captured by the monitor you uploaded.

    But Lighthouse (see your Chrom(ium) browser devtools) does show me a time-to-first-byte — TTFB — of more than 7 seconds when doing the postcode search. (It also shows me a TTFB of 1.9 seconds when loading the /delivery/ form, so it looks like your search costs an extra 5 seconds or so.

    If this were my project, my next stop would be the Query Monitor plugin. I would use it to peer into the steps it takes to render that search-results page.

    • This reply was modified 10 months ago by OllieJones.
    Thread Starter criserjjio

    (@criserjjio)

    Hi Ollie
    Thank you for checking!

    I installed Query Monitor plugin to check the slow queries
    and so far only showing 3, they are showing around 0.05 to 0.07timings

    Is there anything you can suggest like a plugin configuration or setting using the Index WP plugin to improve the 7s loading time?

    Thread Starter criserjjio

    (@criserjjio)

    Hi just checking if you have any other suggestions using the Index WP plugin to improve the 7s loading time?

    Many thanks ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Check speed comparison’ is closed to new replies.