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-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev