Very Slow Speed for importing Listings

This topic contains 9 replies, has 3 voices, and was last updated by  Paolo 9 years, 10 months ago.

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • June 19, 2015 at 5:43 am #43054

    kevintodler
    Free User
    Post count: 48

    Hi Stiofan,
    I have got into huge problem of importing 0.1 million listings.

    I have imported 50000(fifty thousand listings in to the geodirectory) till date.
    But now the import process is running very slow i.e., 100 listings for 1 hour which is very slow compared to what I had started in the first place.

    I don’t know what exactly is causing it to become slow.

    My server plan is http://mochahost.com/vps.php
    Perfetto5
    50% Spring Discount
    $59.95/mo $29.98/mo

    3 GB 4 GB RAM Guaranteed
    8 GB RAM Burstable
    4 CPU Cores
    9.6 GHz Total CPU Power
    150 GB 200 GB Disk Space
    UNMETERED Monthly Traffic
    1,000 mbps VPS Network Port
    Uptime Guarantee
    Droid or i-phone Support
    NEVER Reboot Protection
    Super SSD Cache
    Free SSL (256 bit) β
    WordPress Optimized
    Tomcat/Java Support *

    It is not raising any memory error or any such thing but it is running quite slow.

    I used the latest version of Geodirectory earlier but failed to get the results. I have reinstalled old version Geodirectory as I had files formatted for this version of Geodirectory.

    Could you please check the site to see what actually is causing the problem.

    June 19, 2015 at 5:47 am #43055

    kevintodler
    Free User
    Post count: 48
    This reply has been marked as private.
    June 19, 2015 at 6:03 am #43056

    kevintodler
    Free User
    Post count: 48
    This reply has been marked as private.
    June 19, 2015 at 6:19 am #43059

    kevintodler
    Free User
    Post count: 48
    This reply has been marked as private.
    June 19, 2015 at 9:45 am #43068

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Your site is telling me, error establishning DB connection.

    Stiofan

    June 19, 2015 at 1:20 pm #43082

    kevintodler
    Free User
    Post count: 48

    Hi stiofan,
    . please check again.

    It is working on my side.

    Site details:

    Website: http://restaurants.directory/

    June 19, 2015 at 1:38 pm #43085

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Thanks, your plugin is WAY out of date, we have a totally new import/export system. I would update first.

    Stiofan

    June 19, 2015 at 6:49 pm #43105

    Paolo
    Site Admin
    Post count: 31211

    Just FYI, the new import/export system is performing ajax calls to check 1st if all data is valid, if the listing ID is already existing, how many images there are per listing and so on.

    It process 5 rows at a time. On our dedicated server it takes apprrox 1.2 sec per listing. 140 listings where imported in a little over 3 minutes.

    Thanks

    June 20, 2015 at 4:29 am #43156

    kevintodler
    Free User
    Post count: 48

    HI Paolo,
    It approximately takes one hour to import 100 listings on my server.

    I don’t know what actually is causing the problem here.

    According to you what should be the server configuration when trying to run 0.1 million listings with Geodirectory.

    can you provide a tool that will help me monitor the actual memory usage and processor usage by my website at any point of time.

    I am really desperate to complete this task of importing.

    Regards,

    Kevin

    June 20, 2015 at 2:40 pm #43169

    Paolo
    Site Admin
    Post count: 31211

    Hi Kevin,

    currently you are using a version of GeoDirectory that is over 10 sub-version below current version.

    Please update everything and try again. Than we will discuss if it’s still slow or not.

    In any case for over 30k listings I would always recommend a Dedicated server.

    Thanks

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 10 total)

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount