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

Mike Bayer mbayer at redhat.com
Tue Apr 21 13:45:53 UTC 2015

On 4/21/15 2:47 AM, 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.
just keep in mind that more indexes will place a performance penalty on 
INSERT statements, particularly at larger volumes.  I have no idea if 
that is important here but something to keep in mind.

> Cheers,
> Ajaya
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150421/417af6f4/attachment.html>

More information about the OpenStack-dev mailing list