See if 1000 sites can be called for one timestamp

[peterdudfield]

Detailed Description

See if 1000 sites can be called in the api, but just for 1 timestamp

Context

• we restricted to 100 sites at once, but this gets forecast and history

Possible Implementation

• run api locally connected to dev
• get 1000 sites uuids
• get forecast for 1000 sites for 1 timestamp
• write down how long the query too (Q: could this be quicker?)

[peterdudfield]

I tried the pv_forecast route, and for 2 sites and 2 timestamp it took 45 seconds. Interestingly it the query longs the past values and then the future values. The future values were taking a long time, the past were very quick

[peterdudfield]

Some SQL tweaks seemed to help, will push a PR