I've loaded a v.large shapefile (~2GB) into Spatialite in QGIS and a non-spatial table (from a csv, 8 MB) in there as well (via the QSpatialite GUI).
They have successfully been joined in QGIS. They also display as a relation (because there is a one to many relationship between a polygon and 1 or 5 records in the table).
As far as I know there is an index for the polygons.
Whats the most efficient way to create a new joined layer? To pass on to another user.
Layer|SaveAs dialog work for adding a Spatialite layer to an existing db? It doesn't time out for me as there is too much data)