ASWWU-Web / python_server

The API server for ASWWU Web. This project uses the Tornado web framework to serve and manage data across all ASWWU sites.
https://aswwu.com/server
4 stars 10 forks source link

potential speed improvement for search/all #168

Closed ermsdev closed 1 month ago

ermsdev commented 4 years ago

the search/all endpoint is currently cached because it has been slow historically. I recently noticed in the code that it appears to be returning the entire profiles table through sqlalchemy, and then filtering it in python before sending it to the client. this could probably be improved by just returning the four fields that are needed with sqlalchemy before sending them to the client.

rileyallyn commented 1 month ago

hopefully fixed in #207