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

Ajaya Agrawal ajku.agr at gmail.com
Tue Apr 21 06:47:27 UTC 2015


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.

Cheers,
Ajaya
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150421/500dde8c/attachment.html>


More information about the OpenStack-dev mailing list