How do I return related models over RESTful API using loopbackjs?

Question

I am evaluating loopback as the API server for a new project. I need to return data in a format specific to Ember and I need to return either: an array of IDs to related models, or an embedded array of the related models objects.

I have experimented with using the Include filter to automatically include the related models (using hasMany relationship type). When we do basic performance testing we find that the include filter adds a significant performance penalty.

What is the best performing method for getting access to the related models?

IvanZh · Answer 1 · 2015-03-19T17:42:20.830

0

Assume that we have category that hasMany products.

To get products, related to category, request the /api/category/:id/products endpoint.

Also you can use limit and fields filter for better performance.

edited Mar 19 '15 at 17:42

answered Mar 19 '15 at 09:07

IvanZh

2,265
1
18
26

Thanks, but that is for the Angular SDK. I'm trying to work with Ember. there is currently no Ember SDK :-( – Mark Lummus Mar 19 '15 at 13:43
Ah, I missed it, sorry! I totally updated the answer. – IvanZh Mar 19 '15 at 17:38
we had a limit of 30 records and specified the fields we wanted. as an example of how bad it is, we wrote our own query logic for find() that includes related models. avg 310ms for ours, avg 2400ms for native code. as in 2.4 SECONDS to return the first 30 records. – Mark Lummus Mar 19 '15 at 19:19
Good, please create an issue or perform a pull request in DB connector repo to improve it! – IvanZh Mar 20 '15 at 07:03
@MarkL, BTW, what kind of connector do you use? – IvanZh Mar 20 '15 at 07:06
we are using the postgresql connector. – Mark Lummus Mar 20 '15 at 13:06

How do I return related models over RESTful API using loopbackjs?

1 Answers1