Hi Robert,
I've not used reference properties. Its a simple query and it'll be
like this.
q = db.Query(PrimaryData)
q.filter('SheetMetadataId', metadata.getSheetId())
q.filter('InstanceAssignedTo IN',
[u'User_c42e8919_448e_11e0_b87b_f58d20c6e2c3',
u'User_1fd87ac5_073d_11e0_8ba1_c122a5867c4a'])
return q.fetch(2000)
and I replaced the IN filter to '=' with single value. Still its
taking same time.
On Mar 17, 6:27 am, Robert Kluin <[email protected]> wrote:
> Use Appstats. It may not be the query that is slow. If you are using
> reference properties, perhaps you are dereferencing them. If you
> should us the query and how you're using the results we might be abel
> to give more suggestions.
>
> http://code.google.com/appengine/docs/python/tools/appstats.html
>
> Robert
>
>
>
>
>
>
>
> On Mon, Mar 14, 2011 at 10:54, adhi <[email protected]> wrote:
> > Hi, I'm running a query in appengine which is returning just 1200
> > entities, but its taking 3.5 seconds. The query doesn't contains
> > inequality filters, but anyway I added index for that. Can anyone tell
> > me how to analyse this and improve theperformance?
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Google App Engine" group.
> > To post to this group, send email to [email protected].
> > To unsubscribe from this group, send email to
> > [email protected].
> > 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
