Content management screen loading takes too long

[JohnONolan]

When running a deployed instance of Ghost and clicking on "content" in the main nav of the admin - there is a 1.5 - 2 second delay before the content actually loads in.

This is a really noticeable lag.

I'd like to do 2 things here:

1. Research / experiment. Can we actually make this load faster?
2. Animations

We can reduce the impact of the load delay (poor UX) with some light animations when the content does actually load (nice UX). I have two specific animations in mind:

• Fade in each post (0.3s each) in the left column, one by one, with a 0.25s delay between each one. This should fade in all of the posts quickly, in order, in a kind of accordion effect from top top bottom.
  • Note: We only need to animate the first 10 posts, as that is the maximum likely to ever to fit on the screen at any one time.
• Once all posts in the left hand column have loaded, fade in the content preview in the right hand column over 0.5s

[ErisDS]

This would be partly resolved by introducing caching: #173

Also by reducing the number of posts requested at the start (11 I think) and adding infinite scroll #48

[JohnONolan]

FWIW the 2 second delay is occurring with just a single post in the DB

[ErisDS]

Fair point. This probably warrants a bit of investigation to locate the bottleneck, but I'm pretty sure it's the uncached request more than anything else.

[ErisDS]

Should we have loading animations to appear in spaces before content loads?

[JohnONolan]

Was thinking about that - maybe - but let's see if we can actually speed it up first - if not, then we should look at adding a spinner or two.

[ErisDS]

The first ever load without is always going to be slow. I would recommend adding it so that it is there for when it is needed. If things are loaded out of cache, they should be so fast the spinner won't appear.

[ErisDS]

One other thing to note: Amazon EC2 is slow, and expensive. It might not be something we advocate.

[JohnONolan]

This ticket may relate to the email I just forwarded you, subject: "Our AWS bill" heh

[ErisDS]

Drafting a response :)

[ErisDS]

I've pushed a small fix that should improve this a small amount. Other than that I think this is down to two things

• pagination in SQL being slow: Paginated queries are too slow #110
• the number of JS files that have to be downloaded before the query is made: Infra: JS build for admin client #359

I'm going to punt this for review in 0.4 if these 2 issues haven't improved things.

[ErisDS]

@JohnONolan worth checking this again with @jgable's changes

[ErisDS]

Closing this as I think it's no longer a problem