WordPress website slow performance issue in Vertica

SullivanSullivan Vertica Customer
in General Discussion

I have noticed that my WordPress website is experiencing slow performance when using Vertica as the database. The website takes a long time to load pages, and sometimes it even times out. I have tried optimizing the database and caching the website, but the issue persists. Has anyone else experienced similar issues with WordPress and Vertica? Any suggestions on how to resolve this issue would be greatly appreciated. Thank you.

Tagged:

Answers

  • moshegmosheg Vertica Employee Administrator

    There are three common ways to troubleshoot a slow dashboard or website:
    1. Cache the page you are trying to browse on the site.
    2. Profile one of the queries to check which execution step is taking more time.
    3. Run the same query locally in VSQL to compare the time it takes to run on the server versus remotely.
    If you have already cached the website and are still experiencing slowness, the problem probably does not relate to Vertica.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...