[Qgis-developer] Python scrpt to join attributes from DBF - ftools
is very slow
tech_dev at wildintellect.com
Sun Jan 16 22:48:56 EST 2011
How much ram does your laptop have? This can be a major bottleneck with
the dataset size you're talking about. Consider adding more if you
aren't maxed out.
On 01/16/2011 05:28 AM, Noli Sicad wrote:
> 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
> 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
> The data that I am working is country database in village level.
> 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
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
More information about the Qgis-developer