The order of the filters does not have an effect on the performance (the zigzag algorithm we use does not give preference to any index scans it is performing).
On Tue, Nov 1, 2011 at 2:45 AM, Matthew Jaggard <[email protected]>wrote: > Regarding the index selection shown here: > http://code.google.com/appengine/articles/indexselection.html > > is it possible / required to put the query in the right order to get > the best performance? > > For example, if I have a lot of black and white photos and just a > handful of panoramic ones, does the first query below behave > differently compared to the second? > SELECT * FROM Photo WHERE colouration=<black & white> AND > aspect=<panoramic> ORDER BY date_added DESC; > SELECT * FROM Photo WHERE aspect=<panoramic> AND colouration=<black & > white> ORDER BY date_added DESC; > > On 1 November 2011 01:13, Marzia Niccolai <[email protected]> wrote: > > Hi, > > We've just uploaded the 1.6.0 Prerelease SDKs: > > http://code.google.com/p/googleappengine/downloads/list > > Please note that new features are not available in production until the > > final release, and documentation for these features will be available at > > this time as well. Let us know if there are any issues found. > > Below are the release notes for this release. > > Thanks, > > Marzia > > > > App Engine Python SDK - Release Notes > > > > Version 1.6.0 > > =============================== > > - On November 7th, App Engine will be out of Preview. The new Terms of > > Service > > and previously announced pricing changes will be in effect. > Additionally, > > all > > paid apps are now covered by our SLA. > > http://www.google.com/enterprise/cloud/appengine/pricing.html > > - Paid apps can now specify the maximum pending latency for instances and > > the > > minimum number of idle instances for your application in the Admin > > Console. > > - We have released an experimental utility, available in the Admin > Console, > > to > > assist in migrating your application to the High Replication datastore. > > This > > utility allows you to copy the bulk of your data in the background, > while > > the > > source application is still serving. You then need a brief read-only > > period to > > migrate your application data while you copy the data that has changed > > from > > the time the original copy started. > > - Blobstore, which was previously limited to apps with billing enabled, > is > > now > > available for all apps. > > - We have published a new article on Datastore Index Selection and > Advanced > > Search which explains our recent improvements to the query planner that > > make > > exploding indexes unnecessary. > > http://code.google.com/appengine/articles/indexselection.html > > - Applications can now receive xmpp error stanzas at /_ah/xmpp/error. > > - In the Admin Console data viewer, you can now filter by namespace from > a > > drop > > down menu, if applicable. > > - In the Admin Console's Datastore Statistics, we now offer namespace > > suggest > > for filtering stats. > > - We have released as experimental the full MapReduce framework. > > - The mail_stub.get_sent_messages() call now returns EmailMessage > instances. > > - Fixed an issue when setting an initial_value in memcache.incr > unexpectedly > > returned a string. > > http://code.google.com/p/googleappengine/issues/detail?id=2012 > > - Fixed an issue where DoS stats in the Admin Console didn't work for > High > > Replication apps. > > http://code.google.com/p/googleappengine/issues/detail?id=5237 > > > > App Engine Java SDK - Release Notes > > > > Version 1.6.0 > > ============= > > - On November 7th, App Engine will be out of Preview. The new Terms of > > Service > > and previously announced pricing changes will be in effect. > Additionally, > > all > > paid apps are now covered by our SLA. > > http://www.google.com/enterprise/cloud/appengine/pricing.html > > - Paid apps can now specify the maximum pending latency for instances and > > the > > minimum number of idle instances for your application in the Admin > > Console. > > - We have released an experimental utility, available in the Admin > Console, > > to > > assist in migrating your application to the High Replication datastore. > > This > > utility allows you to copy the bulk of your data in the background, > while > > the > > source application is still serving. You then need a brief read-only > > period to > > migrate your application data while you copy the data that has changed > > from > > the time the original copy started. > > - Blobstore, which was previously limited to apps with billing enabled, > is > > now > > available for all apps. > > - We have published a new article on Datastore Index Selection and > Advanced > > Search which explains our recent improvements to the query planner that > > make > > exploding indexes unnecessary. > > http://code.google.com/appengine/articles/indexselection.html > > - Applications can now receive xmpp error stanzas at /_ah/xmpp/error. > > - In the Admin Console data viewer, you can now filter by namespace from > a > > drop > > down menu, if applicable. > > - In the Admin Console's Datastore Statistics, we now offer namespace > > suggest > > for filtering stats. > > - Added API functionality for making calls to the Memcache API > > asynchronously. > > - In the Memcache API, getIdentifiable() and putIfUntouched() now support > > batch operations. > > - We've added a page, /_ah/admin/capabilitiesstatus, to the dev console > that > > allows you to configure the capability state of the local API > > implementations > > when running locally. > > - We've added LocalCapabilitiesServiceTestConfig to the testing API, > which > > allows you to configure the capability state of the local API > > implementations > > in your tests. > > - The Datastore API now supports callbacks that can execute before or > after > > put() and delete() calls. > > - The queue-name argument is now optional for async-session-persistence > in > > appengine-web.xml. > > - Fixed a ClassNotFound error when using async-session-persistence. > > http://code.google.com/p/googleappengine/issues/detail?id=5774 > > - Fixed an issue with memcache serialization when using a entity key > with a > > name > > that points to the same reference as the key's parent. > > http://code.google.com/p/googleappengine/issues/detail?id=2088 > > - Fixed an issue where DoS stats in the Admin Console didn't work for > High > > Replication apps. > > http://code.google.com/p/googleappengine/issues/detail?id=5237 > > > > -- > > 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. > > > > -- > 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. > > -- 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.
