[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
--
@flaper87
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