improve fetching models from db using single query
|Target version:||2.5 Maintenance|
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).