Method Community

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.

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. 

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.

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

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

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? 

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,

FW