Gateway Time-out failure by using high amount of world city data

This topic contains 4 replies, has 3 voices, and was last updated by  wci 8 years, 12 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #39763

    wci
    Expired Member
    Post count: 1035

    Dear geodirectory Developers,

    I am running with geodirectory into the almost same data consumption problem that I had with geotheme. That is why I migrated to geodirectory with your latest developments and in hope you have solved these problems, but is seems not.

    Referring to a former thread where I stated a problem of not being able to use the multi-city drop-down when it comes to a huge amount of world multi-city files within database existing.

    Problem description:
    After implementing these data and again re-sured from world city data file seller that the files are proper and should be usable I am getting the failure message by using the multi city drop-down.

    Gateway Time-out failure – The gateway did not receive a timely response from the upstream server or application. Additionally, a 504 Gateway Time-out error was encountered while trying to use an ErrorDocument to handle the request.

    According to the advice within the thread stated above I truncated the table wp_1geodir_post_locations and started again with no data. And renamed the older table into wp_1geodir_post_locations-KT-files.

    CONCLUSION:
    So it seems to me that, when it comes through a high amount of world city in combination with a huge amount of listings then geodirectory will not work proper any more?

    I/we need now clarification from the geodirectory developers.

    1. Are you aware about this increasing data volume problem?
    2. Will you develop an update to solve this problem, to enable and assure a stable usage even with high data amount existing?

    MISSION:
    A proper, easy to use, fast and stable system even with huge amount of data are the most important criteria to use and run geodirectory not only for me, even for all customers itself.

    I am looking forward to your reply and leave you with my best regards,
    Alex

    P.S. Please do not misunderstand my intention within this thread, I love your system and want to make sure that this will still stay in nearer future.

    P.P.S. All other readers and customers are invited to add your statements and suggestions for future development to enable a stable high data usability.

    #39775

    Guust
    Moderator
    Post count: 29970

    Can you post the specs of your server? Does it meet the specs identified by the seller of the data?

    #39783

    wci
    Expired Member
    Post count: 1035

    Hi Guust,
    my specs are:
    VPS 6 GB RAM, 150 GB HDD Webspace
    RAM 112,5/64M • SQL 308 • PHPv 5.4.39

    Best regards,
    Alex

    #39805

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Alex,

    Please get me on skype and we can debug it.

    Stiofan

    #39880

    wci
    Expired Member
    Post count: 1035

    This is just a follow up for problem solving of users who read this thread:

    • Problem description over chat:
    Using the world city data of Kevin and activating within database, then by using the mulicity dropdown the system crashes by showing “gateway failure” in browser after a long time…

    • Answer from Stiofan within chat:
    Users can add a city when needed. You can add a place to anywhere in the world and it will then enter the location info at the same time.

    Q: I thought it has to be prior setup as same as geotheme was forced that
    A: I would not add all location info, as it might be slightly diffrent than what google returns and will cause duplicate cities. Even importing a place via CSV will add a location if it’s not in the DB.

    Q: What is when the user implement a wrong name of city e.g. region of Leipzig is Sachsen and in english it is saxony. Is then the system choosing the right name?
    A: You have to set your maps to use one language e.g. english is prefered, and then draggin the marker or clicking sett address on map should fix cities names. If someone does create a wrong city then you can merge two cities.

    Q: How do I have to setup this?
    A: if you have a small directory you can add your own cities and have google not set anything. You can also limit what cities can be selected etc.

    Q: Again about the world city data – let’s say there will be a big amount of entries with cities made within the engl. site. Which would be much more amount of actual implemented entries from Kevins data. Will this then not cause the same problem with the gateway failure?
    A: it shoudl not, only a few are pulled at a time. I don’t understand what problem you are having but if u run into it we will fix it

    Q: That is exactly what I need from you – it is a GO for it to be and make sure that the system will be stable working even with a big data amount….
    A: u should have no problems

Viewing 5 posts - 1 through 5 (of 5 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket