It should be totally safe to use this for Ubuntu as a whole, and perhaps distroseries queries; I don't know if per package, per project searches have enough heat variation to behave nicely. However, I suggest we try just dropping the .id field in the order for heat ordered searches based on a feature flag. If it looks poor on real things, we can easily reinstate it, and then do a more complex index (e.g. a partial one on heat desc, importance desc, bug.id where status is an open status).
It should be totally safe to use this for Ubuntu as a whole, and perhaps distroseries queries; I don't know if per package, per project searches have enough heat variation to behave nicely. However, I suggest we try just dropping the .id field in the order for heat ordered searches based on a feature flag. If it looks poor on real things, we can easily reinstate it, and then do a more complex index (e.g. a partial one on heat desc, importance desc, bug.id where status is an open status).