7 ms·
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 se
by timbowhite 6y ago
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 6y agoOrdering 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.
- deleted 6y ago[deleted]