API call cold start takes too long (CP included)

[vitalijalbu]

Hi guys, I wanted to do some stress testing with statamic (to see how much data it can hold):
here's my playground API url, at cold start (meaning after some hours) it takes so much time... but after the first call it's ok...anyone knows the reason?
CP also is so slow (147k records I have, ok... but the first 50 records of the table must be faster that 1+ minute I suppose)
I use eloquent driver + mysql + siteground (which is one of the faster and best hosting)

https://toovoz.craftus.co/api/collections/items/entries

I attach screenshots before and aftrer

[vitalijalbu]

1st calll

2nd call

[duncanmcclean]

here's my playground API url, at cold start (meaning after some hours) it takes so much time... but after the first call it's ok...anyone knows the reason?

By default, REST API responses are cached for an hour.

[vitalijalbu]

### CP 1st call

### CP 2nd call

[vitalijalbu]

here's my playground API url, at cold start (meaning after some hours) it takes so much time... but after the first call it's ok...anyone knows the reason?

By default, REST API responses are cached for an hour.

yeah ok, but on the cp panel it takes soo long to render table... schema blueprint is simple btw

[duncanmcclean]

You mentioned you're using Siteground - are you using their shared hosting or are you using a VPS?

There are large sites running on Statamic, with the Eloquent Driver without any major performance issues. It's possible it could be a server setup issue.

[vitalijalbu]

You mentioned you're using Siteground - are you using their shared hosting or are you using a VPS?

shared hosting, siteground has 30% php speed than other hostings...