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>