DFID / devtracker-from-api

Current live version of Development Tracker that uses an open public API to present IATI format data
https://devtracker.fcdo.gov.uk
MIT License
9 stars 5 forks source link

Application performance #20

Open johnadamsDFID opened 9 years ago

johnadamsDFID commented 9 years ago

I think we have an emerging problem with application performance. For example it takes around 12 seconds on a dev machine to build the Country Projects Page (on a high-end MBP).

@kouphax @psd I'd be interested to learn of any performance profiling tools you would use for this type of application - I don't know if the problem is the API calls, Sinatra processing of the data or in the munging of the data in the page templates, but 12s for a page isn't acceptable.

siemvaessen commented 9 years ago

@johnadamsDFID could you please provide a URI?

johnadamsDFID commented 9 years ago

Siem, the country page I was looking at is /countries/PK/projects/. I've not got a profiling tool set up yet, but the API URL

http://dfid-oipa.zz-clients.net/api/activities?format=json&reporting_organisation=GB-1&hierarchy=1&related_activity_recipient_country=PK&fields=title,descriptions,activity_status,reporting_organisation,iati_identifier,total_child_budgets,participating_organisations,activity_dates&page_size=1000

takes about 8s in Chrome.