[openstack-dev] Support for multiple sort keys and sort directions in REST GET APIs

Steven Kaufer kaufer at us.ibm.com
Wed Apr 9 16:41:43 UTC 2014


I have submitted a session for the Juno summit for this work:
http://summit.openstack.org/cfp/details/265

Thanks,

Steven Kaufer

Duncan Thomas <duncan.thomas at gmail.com> wrote on 04/06/2014 01:21:57 AM:

> From: Duncan Thomas <duncan.thomas at gmail.com>
> To: "OpenStack Development Mailing List (not for usage questions)"
> <openstack-dev at lists.openstack.org>,
> Date: 04/06/2014 01:28 AM
> Subject: Re: [openstack-dev] Support for multiple sort keys and sort
> directions in REST GET APIs
>
> Stephen
>
> Mike is right, it is mostly (possibly only?) extensions that do double
> lookups. Your plan looks sensible, and definitely useful. I guess I'll
> see if I can actually break it once the review is up :-) I mostly
> wanted to give a heads-up - there are people who are way better at
> reviewing this than me.
>
>
>
> On 3 April 2014 19:15, Mike Perez <thingee at gmail.com> wrote:
> > Duncan, I think the point you raise could happen even without
thischange. In
> > the example of listing volumes, you would first query for the list in
some
> > multi-key sort. The API extensions for example that add additional
response
> > keys will do another lookup on that resource for the appropriate column
it's
> > retrieving. There are some extensions that still do this unfortunately,
but
> > quite a few got taken care of in Havana in using cache instead of
> doing these
> > wasteful lookups.
> >
> > Overall Steven, I think this change is useful, especially from one of
the
> > Horizon sessions I heard in Hong Kong for filtering/sorting.
> >
> > --
> > Mike Perez
> >
> > On 11:18 Thu 03 Apr     , Duncan Thomas wrote:
> >> Some of the cinder APIs do weird database joins and double lookups and
> >> things, making every field sortable might have some serious database
> >> performance impact and open up a DoS attack. Will need more
> >> investigation to be sure.
> >>
> >> On 2 April 2014 19:42, Steven Kaufer <kaufer at us.ibm.com> wrote:
> >> > I have proposed blueprints in both nova and cinder for
> supporting multiple
> >> > sort keys and sort directions for the GET APIs (servers and
> volumes).  I am
> >> > trying to get feedback from other projects in order to have a
> more uniform
> >> > API across services.
> >
> > _______________________________________________
> > OpenStack-dev mailing list
> > OpenStack-dev at lists.openstack.org
> > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
>
> --
> Duncan Thomas
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> 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/20140409/923b8c3c/attachment.html>


More information about the OpenStack-dev mailing list