[timbowhite]

Just a heads up - I tried this random query:

  select * from trips where pickup_latitude < -74 order by pickup_longitude desc limit 10;

Didn't get a result set. The little box in the upper right hand corner stated "Maximum number of pages (16) breached in MemoryPages"

[bluestreak]

Ordering would be memory intensive. There are configurable artificial limits in place on this demo instance. This is just because database takes internet traffic directly. In any other settings these limits can be relaxed, which is default behaviour anyway.