Task #463

improve fetching models from db using single query

Added by Hans Cappelle about 6 years ago. Updated about 6 years ago.

Status:NewStart date:06/07/2012
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-Spent time:-
Target version:2.5 Maintenance

Description

AS IS the service will fetch a model and then pass the cursor to get all the model ids per row. This is fine.

For the Channels and the Alarms however a separate query is executed (with open and close db?) to get these details. Beter to provide a method getModelsWithDetails that uses a query fetching everything at once (join).

History

#1 Updated by Espen Solbu about 6 years ago

  • Target version set to 2.5 Maintenance

Also available in: Atom PDF