Method:API Q&A

Re: API response time terrible since server fiasco last week

furrywombat — Wed, 15 Oct 2014 15:04:47 GMT

LaCrews,

I just ran a test insert loop to a temp table with three fields, all of type text. Took 56.47 seconds to process 100 inserts. Has it always been this slow for you? Has the code changed at all on your end?

Best,

Re: API response time terrible since server fiasco last week

LaCrews — Tue, 14 Oct 2014 21:41:12 GMT

furrywombat

do you have any benchmarks for elapsed time to do an insert? over the last 2 days it's taking ~11 seconds per insert, the table I'm inserting into only has 12 fields.

is this normal?

Re: API response time terrible since server fiasco last week

furrywombat — Mon, 06 Oct 2014 16:57:09 GMT

Not noticing any slowdowns as of today. Thanks for following up.

Re: API response time terrible since server fiasco last week

Method_Carl — Mon, 06 Oct 2014 16:46:12 GMT

There should be now outstanding issues related to API performance at this point. Are you still experiencing degraded performance?

Re: API response time terrible since server fiasco last week

furrywombat — Wed, 01 Oct 2014 19:59:22 GMT

Thanks, Chris. It appears to have recovered a bit since yesterday, but I would still like to have this looked at. We rely on the API for so much, when it's acting slow, our people are being paid good money to sit on their hands for 10% of the day. I don't like that.

Re: API response time terrible since server fiasco last week

Method_Chris — Wed, 01 Oct 2014 19:47:37 GMT

Hi. I will run this down for you. I can't commit an ETA at the moment I will look into it and if there are any updates I will reply to this post.

Thanks for reaching out.

API response time terrible since server fiasco last week

furrywombat — Wed, 01 Oct 2014 16:53:50 GMT

I've noticed that the response time from the API has gone in the dumps since last week. I'm thinking this may have something to do with the revised server setup, but I've been keeping a close eye on the speed over the last several days and it does appear that INSERT and UPDATE statements are taking way longer than they ever have in the past. SELECT queries don't appear to have changed as much, though I haven't really dug into those as much as with the INSERT and UPDATE statements.

Can someone please assure me that this is being looked at? It has been extremely annoying.

Thanks.