[openstack-dev] [glance] Why no DB index on sort parameters

Flavio Percoco flavio at redhat.com
Tue Apr 21 08:51:43 UTC 2015

On 21/04/15 12:17 +0530, Ajaya Agrawal wrote:
>Hi All,
>I see that glance supports arbitrary sort parameters and the default is
>"created_at" while listing images. Is there any reason why we don't have index
>over these fields? If we have an index over these fields then we would avoid a
>full table scan to do sorting. IMO at least the created_at field should have an
>index on it.

I don't think there's an actual reason, OTOH. I'd recommend proposing
a patch and wait for the reviews there. :)


Flavio Percoco
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150421/bc592a5e/attachment.pgp>

More information about the OpenStack-dev mailing list