Hi All,

I just wanted to share some timings and a performance tip that I wasn't previously aware of on the HR datastore (should also apply to MS datastore).

I had a query that was the limiting factor for my page load time. It was taking on avg 280ms to query with two equality filters across a dataset of about 600,000 records. A custom index is not needed because the query contains only equality filters.

After adding a custom index on those fields the average query time dropped to about 50 milliseconds. Interestingly the api_cpu consumed remained exactly the same at 104ms.

John

--
You received this message because you are subscribed to the Google Groups "Google 
App Engine for Java" 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-java?hl=en.

Reply via email to