Speed up Vistazo

[markdurrant]

Vistazo is pretty sluggish to load and to update.

Making it a little speeder will improve the whole experience a lot.

Some speed tests

• New timetable item
  • development: 200ms (with not much data)
  • staging: 12s (with production data)
  • production: 10s, 15s if there is 1 other concurrent request

    Look into

• Mongo indices?
• Optimize mongo structures?
• Use postgres?
• Mongo profiling, Mongo monitoring and Diagnostics
• Optimize slow MongoDB queries using MongoLab

[vincemtnz]

Is vistazo still on heroku?

[tobyhunt]

Yeah, still really slow. I would say almost unusably so.. Take's too long to register a new project assignation.

[taktran]

Everything on production seems to take about 10s+, whereas on staging, it's 200ms+. Need to look into this...

[taktran]

Ah, the problem seems to be related to the database - probably not optimizing the saves/queries properly. The apps takes a while if I put the prod db in staging too.

[taktran]

Speed improvement deployed to production.

Most of the work is in the timetable-items-refactor branch.

Speeds for new timetable item are now:

• development: 5s
• staging: < 400ms
• production: < 400ms

From:

• development: 200ms
• staging: 12s
• production: 10-15s