jfinkels / flask-restless

NO LONGER MAINTAINED - A Flask extension for creating simple ReSTful JSON APIs from SQLAlchemy models.
https://flask-restless.readthedocs.io
GNU Affero General Public License v3.0
1.02k stars 301 forks source link

Fetch all objects to include in one query to improve performance #696

Open Cotix opened 5 years ago

Cotix commented 5 years ago

Using an include results in fetching every object individually, even when this is not necessary. This commit evaluates the given query and uses the resulting objects instead. If your data model is properly configured, the important objects will already be fetched in this query. This improves some of our endpoint time from > 1 minute to 1 second.

ajite commented 5 years ago

Simple but efficient. It did improve the performance of my app and it did not break any of my tests.