search

ohmage / server

The ohmage server application.
37 stars 25 forks source link

add survey_response/function/read details to campaign/read(long) #880

Closed stevenolen closed 8 years ago

stevenolen commented 8 years ago

@hongsudt could you take a look and see if this would kill the server performance? It looks like one of the best ways to improve performance for @jeroenooms' campaign tool.

jeroen commented 8 years ago

Yes so most of the loading time is spent doing all of the /function/read requests to get the response counts for each campaign. If we can instead let the server do a single select COUNT(*) from responses group by campaign or something similar that would be much more efficient.

stevenolen commented 8 years ago

fixed in cc7e56dd8c0957fd56e8d54e84ce480328ad1d91