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

[Alex Mandel]

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.

Enjoy,
Alex

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
> 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
>>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer