New answers tagged google
Logically the service_id field should be defined as a foreign key in trips. However, this is made difficult by the fact it can reference a row in either calendar or calendar_dates. Normally foreign keys in a relational database define a relationship between exactly two tables, not three or more. What I have done in the past is simply skip defining this ...
You could try to add the layer as a raster as described here: Alternative to OpenLayers plugin for QGIS? Or use the quick mapservices plugin: https://plugins.qgis.org/plugins/quick_map_services/ Perhaps loading the layer this way can speed things up.
Top 50 recent answers are included