{"push_id":838442222,"size":3,"distinct_size":1,"ref":"refs/heads/master","head":"718de95ded051fefeef65804b9d94022d9f62df0","before":"8825ddd23820412cdf0997413fd7cc90cacb0f1d","commits":[{"sha":"b949a019f2522a660dbacfd0ead8922d59073cb6","author":{"email":"26be40a44952b34fc377f40c106623a13e3bf917@opendataservices.coop","name":"David Carpenter"},"message":"[#235] This might speed up country page load times\n\nWe have many queries that use optional clauses because we are not\nsure about what is in the data. I think these generally slow things\ndown.\nBecause we know more about the data, we can remove some of these\nbecause weknow for example that projects without a name do not need\nto be shown.\nThe tweak to the sites query fixes a bug that inproves load time on\nthat query\nSplitting the commodities and status queries out of the project query\nI think improves things. Again with these queries we can now loose the\noptional elements, and require to return just one value (Projects are\ncurrently Oil and Gas OR Mining, and each only needs one status (even\nif more are supplied they are duplicates)\nI've split these out and then use a loop in the template to display\nthe correct ones against the correct project.\nI think all of this is decreasing load times.\nBen, you might like to test and inspect what I have done to see if it\nhelps!","distinct":false,"url":"https://api.github.com/repos/OpenDataServices/resourceprojects.org-frontend/commits/b949a019f2522a660dbacfd0ead8922d59073cb6"},{"sha":"9ed2117516215352827d707631b3cba968edf472","author":{"email":"26be40a44952b34fc377f40c106623a13e3bf917@opendataservices.coop","name":"David Carpenter"},"message":"Adds files missing from previous commit - d'oh","distinct":false,"url":"https://api.github.com/repos/OpenDataServices/resourceprojects.org-frontend/commits/9ed2117516215352827d707631b3cba968edf472"},{"sha":"718de95ded051fefeef65804b9d94022d9f62df0","author":{"email":"19dce467b4a8cf012470cf5e6cddf03f36a76240@googlemail.com","name":"Ben Webb"},"message":"Merge pull request #239 from NRGI/235-speed-up-country-page\n\n[#235] This might speed up country page load times","distinct":true,"url":"https://api.github.com/repos/OpenDataServices/resourceprojects.org-frontend/commits/718de95ded051fefeef65804b9d94022d9f62df0"}]}