• Resolved sorabji

    (@sorabji)


    I imported a spreadsheet of 130,000 locations, US only.
    Clustering enabled.
    I zoom in on a city and nothing happens on the web browser. But from the MySQL console I see hundreds and thousands of queries happening the more I zoom in.
    Back on the web browser, the locations start to appear on the map after a few minutes, during which time the map constantly resets and my web server’s load average blasts off.
    What is the best way to speed this up?
    Before making this purchase I had assumed some kind of caching was at work? But I don’t see any caching happening in the database or on the webserver.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author agileLogix

    (@agilelogix)

    I think that of stores are not supported, no plugin can do the job with that amount of stores, we have ways in plugin to make it faster but as all the stores are in US than load on bound feature will also break it as within the view there will be too many stores, we also have stores limit option that show the closest 100 stores such as, I would suggest you to request a refund and look for other solution.

    [ASL_STORELOCATOR stores_limit=”100″]

    Thank you

    Thread Starter sorabji

    (@sorabji)

    Since the locations I have are all over the US I tried rearranging the data into categories, where each of the 50 states was a category, then setting the default zoom level to focus on the state. I’d have to make separate pages for each state, which is no problem. But that only made the maps load somewhat more quickly, still too slow, especially when I zoomed in to large cities, and too much load on the server to ever make it public. For now I’ll forgo requesting a refund while I try other workarounds, but I also want to see if I can make use of this plugin with a more sane-sized dataset. I appreciate and respect the quick response but might go for the refund anyway, just depends. Thanks.

    Plugin Author agileLogix

    (@agilelogix)

    The amount of Stores is more than enough to handle, as they creates markers on page which also memory usage, it will be quite slow.

    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Very slow with 131,000 locations’ is closed to new replies.