<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
<br>
<div class="moz-cite-prefix">On 4/21/15 2:47 AM, Ajaya Agrawal
wrote:<br>
</div>
<blockquote
cite="mid:CAGncKO48kNtGPm6me5V1DWyCa7wG9J+Ftu=emNhy_2me5m_E+g@mail.gmail.com"
type="cite">
<div dir="ltr">Hi All,
<div><br>
</div>
<div>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.</div>
</div>
</blockquote>
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.<br>
<br>
<br>
<br>
<br>
<blockquote
cite="mid:CAGncKO48kNtGPm6me5V1DWyCa7wG9J+Ftu=emNhy_2me5m_E+g@mail.gmail.com"
type="cite">
<div dir="ltr">
<div><br>
</div>
<div>
<div>
<div class="gmail_signature">
<div dir="ltr">
<div>Cheers,<br>
</div>
Ajaya<br>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: <a class="moz-txt-link-abbreviated" href="mailto:OpenStack-dev-request@lists.openstack.org?subject:unsubscribe">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>