craton

SQLAlchemy queries are not lazy enough

Bug #1664707 reported by Jim Baker on 2017-02-14

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	craton	New	High	Unassigned

Bug Description

This is a general bug to prompt some refactoring; it probably needs to be subdivided further.

In general SQLAlchemy queries that performed for supporting endpoints like /v1/hosts (and not /v1/hosts/<host-id>) load too much of the corresponding object graph. In particular this is seen with respect to joining in variables data. This should be controlled via appropriate options to the query.

A corresponding bug is https://bugs.launchpad.net/craton/+bug/1662618, which could use the current eager loading as it is now to support ?...details=all.

Jim Baker (jimbaker) on 2017-02-14

Changed in craton:
importance:	Undecided → Critical
assignee:	nobody → git-harry (git-harry)
assignee:	git-harry (git-harry) → Jim Baker (jimbaker)
importance:	Critical → High

Jim Baker (jimbaker) on 2017-03-15

Changed in craton:
assignee:	Jim Baker (jimbaker) → nobody

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.