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

2015-04-27 Thread Rushi Agrawal
, April 21, 2015 9:45 AM To: openstack-dev@lists.openstack.org Subject: Re: [openstack-dev] [glance] Why no DB index on sort parameters 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

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

2015-04-27 Thread Jay Pipes
From: Flavio Percoco fla...@redhat.com mailto:fla...@redhat.com Sent: Thursday, April 23, 2015 7:52 AM To: OpenStack Development Mailing List (not for usage questions) Subject: Re: [openstack-dev] [glance] Why no DB index on sort parameters On 21/04/15 14

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

2015-04-23 Thread Nikhil Komawar
: Flavio Percoco fla...@redhat.com Sent: Thursday, April 23, 2015 7:52 AM To: OpenStack Development Mailing List (not for usage questions) Subject: Re: [openstack-dev] [glance] Why no DB index on sort parameters On 21/04/15 14:55 +, Nikhil Komawar wrote: Rally is great overall however, we need good

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

2015-04-23 Thread Flavio Percoco
: [openstack-dev] [glance] Why no DB index on sort parameters 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

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

2015-04-21 Thread Ajaya Agrawal
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

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

2015-04-21 Thread Flavio Percoco
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

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

2015-04-21 Thread Nikhil Komawar
] [glance] Why no DB index on sort parameters 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

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

2015-04-21 Thread Flavio Percoco
: [openstack-dev] [glance] Why no DB index on sort parameters 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

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

2015-04-21 Thread Mike Bayer
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