Max
Tue, 16 Mar 2010 11:18:31 -0700
Order by salary means an extra index will be built over this field, which will affect your write speed.
Use a global variable to store max(salary)
On Mar 15, 10:12 am, Takashi Matsuo <matsuo.taka...@gmail.com> wrote:
> Hi,
>
> Perhaps you can order by salary property descending, and just get the
> first one, for getting max value.
>
> max_salaried_employee = Employee.all().order("-salary").get()
> max_salary = max_salaried_employee.salary
>
> hope this helps
>
> --
> Takashi Matsuo
> Kay's daddy
>
> On Mon, Mar 15, 2010 at 11:00 AM, Greg <g.fawc...@gmail.com> wrote:
> > On Mar 14, 3:48 am, pyrocks <kiranbe...@gmail.com> wrote:
> >> here shall we have any max() function available like in oracle to find
> >> max salaried employee.
>
> > In a word, no. You need to store the maximum salary in the datastore,
> > and every time time a salary changes check to see if it exceeds the
> > maximum, and update it if so.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Google App Engine" group.
> > To post to this group, send email to google-appeng...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > google-appengine+unsubscr...@googlegroups.com.
> > For more options, visit this group
> > athttp://groups.google.com/group/google-appengine?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.