hotosm / galaxy-api

Backend to fetch data from Underpass
https://galaxy-api.hotosm.org/latest/redoc
GNU Affero General Public License v3.0
14 stars 5 forks source link

[FEATURE] Include Database Pooling Method on Galaxy-API #252

Closed kshitijrajsharma closed 2 years ago

kshitijrajsharma commented 2 years ago

From load testing , I have figured out when there are lot of request, there are same number of request to database for connection , for eg : if there are 100 requests in API then there will be 100 database connection request along with the queries , which resulted huge performance issue on large number request for long time. Solution will be include pooling on Galaxy-API , so that database connection will be kept open and listening for queries when app starts , and destroys when app shut down image