[Qgis-developer] Python scrpt to join attributes from DBF - ftools is very slow

[Noli Sicad]

I decided to reduce the number of columns of the csv / dbf file and
use spatialite to do this job. Then, I desired table is dump into a
shapefile.

It works but it took more than a hour to accomplish this task.

The resulting spatialite database is 1.0 GB and the shapefile dbf file
( the dump file) is 522.2 Mb.

My laptop is slow in opening the spatialite but hared time opening the
shapefile.

The data that I am working is country database in village level.


Noli



On 1/16/11, Alex Mandel <tech_dev at wildintellect.com> wrote:
> Yes, one option is to do this in a database. I do things like this in
> spatialite all the time. Import your shp and your table then do a join
> either temporarily as a view or make a new table.
> SELECT * FROM shp JOIN table on shp.id = table.id
>
> Enjoy,
> Alex
>