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

Release the connection when ogr2ogr is working , and maintain the same connection through all of query in API #261

Closed kshitijrajsharma closed 2 years ago

kshitijrajsharma commented 2 years ago

With the connection pooling for each request , even though the small query should share the same connection and and make sure they don't leak the memory + connection when they do that ! And also when ogr2ogr launches it fires up multiple connection to fetch data , now API needs to take care of the connection and close it even though ogr2ogr fires up new connection , And when process finishes up it needs to come back and put connection to the pool