Import speed getting slower – Urgent

This topic contains 30 replies, has 3 voices, and was last updated by  Benjamin Schmitz 7 years, 5 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • December 5, 2016 at 1:40 pm #319061

    Benjamin Schmitz
    Expired Member
    Post count: 59

    Hey guys,

    I’m in the process of uploading listings and I have noticed that the import speed is getting significantly slower after each upload.

    I’ve uploaded 70.000 listings so far from the total number of 230.000 listings. Simple calculation says that uploading a file with 10.000 listing will take 6 hours to upload as it takes approx. 25 seconds to upload 10 listings.

    That seems to me a bit odd.. While I started uploading, the first uploaded file with 10.000 listings was uploaded within 3 hours. So it’s doubled now.

    I’ve tried to make a smaller files at this point with up to 2.000 listings per sheet, but it still takes 25 seconds/10 listings.

    Wordpress installation is running on Dedicated Server – Atom C2750, 8cores X 2.4GHz, 8GB DDR3, 512GB SSD

    Wordpress, GeoDirectory and all extensions updated to the latest version.

    Do you have any suggestion how to improve the import speed? As it will take a week to get it uploaded this way.. Which we don’t have..

    Thanks

    December 5, 2016 at 1:44 pm #319064

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Do you have any other plugins running that might be adding hook actions to post save or category save?

    Stiofan

    December 5, 2016 at 1:49 pm #319067

    Benjamin Schmitz
    Expired Member
    Post count: 59

    Hi Stiofan,

    No It’s a plain WP installation running on Supreme Directory theme, WPDG plugin with extensions and the only plugin that is not related to WPGD is the buddypress and enabled maintenance mode.. Nothing else.

    December 5, 2016 at 1:51 pm #319098

    Benjamin Schmitz
    Expired Member
    Post count: 59
    This reply has been marked as private.
    December 5, 2016 at 2:02 pm #319134

    Benjamin Schmitz
    Expired Member
    Post count: 59

    Follow up – My CSVs are having around 20 custom fields which are empty. The only header fields with data are the location fields (city, address etc), expire, package ID, post_title, content, category, phone and image. Other 20 fields are empty and available for user input after the claim is made.

    Is it necessary to have headers with empty columns in the CSV? I’m thinking if only the ones that contains data were being imported, it might be faster?

    December 5, 2016 at 3:51 pm #319209

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    OK, please provide wp-admin and FTP info and i will check things over.

    Thanks,

    Stiofan

    December 5, 2016 at 4:01 pm #319226

    Benjamin Schmitz
    Expired Member
    Post count: 59
    This reply has been marked as private.
    December 5, 2016 at 4:22 pm #319282

    Benjamin Schmitz
    Expired Member
    Post count: 59
    This reply has been marked as private.
    December 5, 2016 at 5:39 pm #319308

    Benjamin Schmitz
    Expired Member
    Post count: 59
    This reply has been marked as private.
    December 5, 2016 at 6:13 pm #319317

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Ben,

    I will work on improving the import but it will take a but of time.

    For the locations, i am not sure what you mean, switching locations where?

    Stiofan

    December 5, 2016 at 6:23 pm #319320

    Benjamin Schmitz
    Expired Member
    Post count: 59

    At main menu, location switcher.
    After the state is selected it takes a lot of time to refresh the city list in order to display them.

    I don’t mind waiting a sec or two, but anything above that makes it very user unfriendly.

    Any ideas on that? Thanks guys

    December 5, 2016 at 6:30 pm #319324

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    I am not sure what you mean, i select a region in the menu and it takes me to the locatin page of that region (i see no delay)
    i can then click the city tab on that page and i see cities and no delay.

    Please explain step by step how i can recreate this.

    Thanks,

    Stiofan

    December 5, 2016 at 9:34 pm #319435

    Benjamin Schmitz
    Expired Member
    Post count: 59

    Hmm.. There are no steps to recreate this. Open up the home page and try to switch the Region. It takes almost 20 seconds to be switched to the new region. In that time, the spinner is spinning in the top tab and it’s saying Waiting for domain.com at the bottom left.

    I’m not sure how you get it to load without a delay, because that’s not what’s happening.

    Thank you

    December 5, 2016 at 9:46 pm #319443

    Benjamin Schmitz
    Expired Member
    Post count: 59
    This reply has been marked as private.
    December 5, 2016 at 11:09 pm #319459

    Benjamin Schmitz
    Expired Member
    Post count: 59
    This reply has been marked as private.
  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 31 total)

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

Open Support Ticket