Large Database and Very Slow Query

  • onemlidegil

    (@onemlidegil)


    8 years ago

    The original size of the database view above

    The original size of the second screen view above

    Hi,

    I have more than 49000 total locations (all provinces, cities and neighborhoods) in wp_terms, wp_termmeta and wp_term_taxonomy tables.

    I have arranged the wordpress database without adding any new table or deleting.
    I just organized my own datas in accordance with WordPress’ table structure and then inserted them into the wp_term, wp_termmeta and wp_term_taxonomy tables. All the location rows are working correctly when you use a search form. The problem is my site’s fatal slowness.

    The property-neighborhood query which is performed by Essential Real Estate plugin and can be seen in second screen view takes too much time, approximately 1 – 2 minutes.

    The query is performed wherever you are on the site, even if you’re in the admin panel.

    The site can’t be used.

    What do you suggest me to do?

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author g5theme

    (@g5theme)

    8 years ago

    Hi,
    Website speed depends on internet speed and server configuration, you should try many times to get accurate results. Thanks

    Thread Starter onemlidegil

    (@onemlidegil)

    7 years, 12 months ago

    There is no problem with my server. I tried it on many fast servers.
    This plugin is definitely not suitable for those who has big location datas, in its present form.

    Thread Starter onemlidegil

    (@onemlidegil)

    7 years, 11 months ago

    A professional real estate agency that wants to add all neighborhoods in its country can not use this plugin.

    Please work on fixing this issue.

    Thanks

    lotharzorn

    (@lotharzorn)

    7 years, 7 months ago

    @g5 Team

    congrats for 1 of the best apps which are available.

    Your project is mainly complete, missing so far the resolution for the mentioned problem above.

    I am in front of the same problem and feel a bit sad, because I didn’t expect that a simple query will limit your good concept.

    I have 1 country, 27 states, 8192 cities and 51.500 neighborhoods.

    Please let me know if can you solve it for me.

    My WhatsApp is +1 484 481 1758.

    Thanks Lothar

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

The topic ‘Large Database and Very Slow Query’ is closed to new replies.

Tags