slow api endpoint

  • comptoirdesmonnaies

    80 berichten

    Frankrijk

    Hi Delcampe Team

    We are using this endpoint to get our inventory weekly
    Link (https)

    The response time up to 60s for 500 items (with timeout sometimes), we have 270K opened items ..

    can you check why it's so slow ?

    Regards
  • comptoirdesmonnaies

    80 berichten

    Frankrijk

    Hello

    As you can see on attached screenshot, API timeout on requests with high offset, according seller dashboard we have 270878 items opened but we can not retrieve the latest 10K from API without 504 error.

    Can you fix please ?
  • comptoirdesmonnaies

    80 berichten

    Frankrijk

    is there is someone from delcampe team looking threads on this forum sometimes ? :d-unhappy: :help:
  • @dorian
    Beheerder

    69 berichten

    België

    Hello comptoirdesmonnaies,

    An improvement will be released on monday for this issue.
    Our apologies for the delay.

    Have a nice day,
    --
    Dorian
  • comptoirdesmonnaies

    80 berichten

    Frankrijk

    @dorian

    Still not working :no:
  • @kevin
    Beheerder

    102 berichten

    België

    Hi comptoirdesmonnaies,

    The modification was posted online on Tuesday the 24th in the afternoon.
    Have you still had the problem since the update ?

    If yes, could you do another capture with the problematic call ?

    Best regards,
    --
    Kevin
    Delcampe Team
  • comptoirdesmonnaies

    80 berichten

    Frankrijk

    Hi @kevin

    Got less 504 but it tooks about 50s for each call with 100 items per page, with 270k live items it means about 2 days (without errors) to get inventory, not acceptable. Moreother i can not increase numberOfItems without 504 error (see enclosed).
    Upgrading server timeout is not enough, performance must be improved on this endpoint.

    Regards
  • Servitel

    448 berichten

    Zwitserland

    Hi Comptoirdesmonnaies
    We use the same endopoint for download all inventory for all our customers and we don't experience this issue. Our call ask 1000 items (the maximmum) each

    Where are located your servers ?
    Are you able to check with traceroute the time for every hop ?
  • comptoirdesmonnaies

    80 berichten

    Frankrijk

    Hi Comptoirdesmonnaies
    We use the same endopoint for download all inventory for all our customers and we don't experience this issue. Our call ask 1000 items (the maximmum) each

    Where are located your servers ?
    Are you able to check with traceroute the time for every hop ?
    • Aangemaakt 28 okt 2023 op 05:46
    • #1620861
    Hi Servitel

    Thanks for you help.
    How many items max got your customers ? this becomes longer and longer as the offset increases and got random 504 from 250K.

    Regards
  • Servitel

    448 berichten

    Zwitserland

    Hi Servitel

    Thanks for you help.
    How many items max got your customers ? this becomes longer and longer as the offset increases and got random 504 from 250K.

    Regards
    • Aangemaakt 30 okt 2023 op 03:43
    • #1621734
    Max items count for my customer is 230k

    Average is 80k

    You can check if the problem is at your end by using the program I have sento to you by message
  • comptoirdesmonnaies

    80 berichten

    Frankrijk

    Max items count for my customer is 230k

    Average is 80k

    You can check if the problem is at your end by using the program I have sento to you by message
    • Aangemaakt 30 okt 2023 op 03:47
    • #1621740
    Thanks for your help

    Unfortunately for security reasons we can not share a token with write access and there is no way to limit scopes with Delcampe.
    Server are located in France, i will try traceroute, how long does it took (avg) to retrieve 1K from your side ?

    Regards
  • Servitel

    448 berichten

    Zwitserland

    Thanks for your help

    Unfortunately for security reasons we can not share a token with write access and there is no way to limit scopes with Delcampe.
    Server are located in France, i will try traceroute, how long does it took (avg) to retrieve 1K from your side ?

    Regards
    • Aangemaakt 31 okt 2023 op 04:10
    • #1622370
    Hi CDM
    sorry for late answer, but there is not an email alert when a new post is done

    Tried for some clients, the average time for retrieve 1000 items is 3 seconds
  • comptoirdesmonnaies

    80 berichten

    Frankrijk

    Hi CDM
    sorry for late answer, but there is not an email alert when a new post is done

    Tried for some clients, the average time for retrieve 1000 items is 3 seconds
    • Aangemaakt 2 nov 2023 op 11:09
    • #1624362
    Hi @Servitel

    Can you try for your largest customer inventory (the one with 230K ?)
    Avg response time for us is 50s when it doesn't end with 504.
    I have tried from my localhost instead of server with same results.

    Regards
  • @dorian
    Beheerder

    69 berichten

    België

    Hello comptoirdesmonnaies,

    An improvement ticket has been open to go further in this performance issue.

    Have a nice day,
    --
  • Servitel

    448 berichten

    Zwitserland

    hi @comptoirdesmonnaies
    the time is the same: 2/3 seconds for 1000 items

    I use all parameters startingItem, numberOfItems and order

Word lid van de verzamelaars-community!

Registreren Aanmelden