Speed up /history render

[mattbk]

Depends on data frequency, obviously.

[mattbk]

Not sure if this is a query thing or a network asset thing.

[mattbk]

More likely JS.

[mattbk]

[mattbk]

plotly.js is 5.6 MB, no wonder it takes forever.

Minified version is smaller: https://plot.ly/javascript/getting-started/#download

[mattbk]

I think it's actually the page itself taking so long. 30 seconds for 24 hours of data?

[mattbk]

JS is slow but is cached after first load.

[mattbk]

• Try sending the JSON but not rendering in Plotly. --> Does not increase speed.
• Try calculating but not sending JSON.--> Does not increase speed.

[mattbk]

It's in the database/plot creation logic.

[mattbk]

Cutting out the timezone conversion cuts load of the page itself from ~17s to ~4s.

[mattbk]

This is what is being used right now: http://arrow.readthedocs.io/en/latest/

I wonder if the for() loop itself is the issue. https://medium.com/python-pandemonium/never-write-for-loops-again-91a5a4c84baf