WordPress Azure

  • ctoriz

    (@ctoriz)


    6 years ago

    i developed custom forms with custom table, and i get 2 issues.
    1.- some times the wp-admin show me a message “error database connection”. but if i only refresh the page, the message dont show again and i can work.
    2.- the forms include a droplist down whit querys to database for show the list and takes to load the lists for show.

    Some one have idea of how i cant fix it o what happens on it?

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator bcworkz

    (@bcworkz)

    Intermittent DB connection errors are invariably due to communication issues external to WP. When WP causes an error, it tends to do so consistently.

    I get that you make queries to populate drop down lists on your form, but it’s not clear what issue you are having. If it is intermittently failing to populate, it’s probably due to the same DB connection problem. “Tipo” only loads after selecting “Asunto”, but it’s always the same content. Is that what the intention is? “Tipo” is also rather slow to load. I didn’t see any DB connection errors or evidence to that effect.

    Thread Starter ctoriz

    (@ctoriz)

    Ok thank you for your answer, the erro of database connection is showing some times.
    but is normal that it be rather slow to fill the lists? What kind of problems do I face?

    Thank you

    Moderator bcworkz

    (@bcworkz)

    There can be a noticeable delay, but this is much slower than usual. Longer delays can result from complex queries on huge databases. I assume this is not the case here. Delays can be due to overloaded servers. I’ve no experience with Azure, but I wouldn’t expect them to do that. However, DB connections fall within their purview. It seems their quality and reliability may not be what I’m expecting. To be fair, there are many factors involved with communications and the fault could lie elsewhere.

    It seems the “Tipo” dropdown always has the same content regardless of the pick in “Asunto”. If that is normal, it would be faster to simply populate the field when the page is served. It’s either that or there is a problem with the query run to populate “Tipo” which would result in different content dependent upon “Asunto” selection.

    Thread Starter ctoriz

    (@ctoriz)

    Hi i was checked the the tables on database and found some tables does not have any index, so i assigned one index on then.

    With that i reduced time of 10 seconds to 3 second currently.
    but for my customer is not enogh.

    Ill tell you what else i can do for better up this forms

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress Azure’ is closed to new replies.