[Qgis-user] Incredibly slow performance using QGIS v2.10

Sun Aug 30 14:42:25 PDT 2015

Hi, 
I suggest to take the joined saved .shp file and use the Saga version of dissolve.  Using the Spatialite (click on layer and save shp as Spatialite) file could make things faster but the problem here is, to my knowledge, not the file format.  It's the QGIS dissolve.  See below. 
http://gis.stackexchange.com/questions/79850/merge-large-number-of-polygons-using-qgis 
Saga (processing plugin) will ask for a field for this dissolve.  Select the zip field or create a new Field with a dummy variable if you want to dissolve all.  (Use the field calculator if you which to  create this dummy variable).  If you see slivers, you can set a tolerance level (unit will be the unit of your CRS). 
Good luck! 
Nicolas Cadieux M.Sc. 
Les Entreprises Archéotec inc.  
8548, rue Saint-Denis Montréal H2P 2H2 
Téléphone: 514.381.5112  Fax: 514.381.4995 
www.archeotec.ca 
On Aug 30, 2015 16:47, "Ken Walenga [via OSGeo.org]" <ml-node+s1560n5221860h21 at n6.nabble.com> wrote: 

	I have replied to your questions in-line, below: On Sun, Aug 30, 2015 at 11:03 AM, Alex Mandel < [hidden email] > wrote: <blockquote style="border-left:2px solid #cccccc;padding:0 1em" style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex">Kenneth, 

How many records, and how much memory do the files take on disc? The Zip.shp file contains 41,342 rows and takes up ca. 400KB on disk. The Zip2Terr.csv file contains 87,632 rows and occupies 4KB on disk. <blockquote style="border-left:2px solid #cccccc;padding:0 1em" style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex">

Are you joining the SHP and the CSV and then doing Dissolve? Yes. <blockquote style="border-left:2px solid #cccccc;padding:0 1em" style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex"> Did you 
save the joined layer to a new file? Yes <blockquote style="border-left:2px solid #cccccc;padding:0 1em" style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex">Does this shapefile have a spatial 
index created? Yes <blockquote style="border-left:2px solid #cccccc;padding:0 1em" style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex"> Is the topology of the polygons clean (are there self 
intersections, lots of slivers, or overlaps? It is clean. There don't appear to be any slivers. <blockquote style="border-left:2px solid #cccccc;padding:0 1em" style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex">

Other than saving the intermediate to a file, the next suggestion is to 
use Spatialite or Postgis databases. Can you elaborate a little on what's involved in using one of the two named databases? Do I simply need to read the .csv file into Spatiallite or Postgres? <blockquote style="border-left:2px solid #cccccc;padding:0 1em" style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex">

Keep in mind, that an operation like this is single threaded. 

Thanks, 
Alex 

On 08/30/2015 09:53 AM, Ken Walenga wrote: 
> Looking for help. I have an unsimplified ZIP.shp file and want to create my 
> own custom boundary files for territories which are a collection of zip 
> code areas. I bring in the Zip.shp file and  join to a Zip2Terr.csv file on 
> the Zip field. When I try to dissolve the TERR_NBR field, the dissolve 
> process can take longer than 2 whole days (!). Any ideas on ways to speed 
> it up? I have tried using a simplified Zip.shp file, but that results in 
> way less than satisfactory boundary files with gaps, etc. Might this be a 
> problem with v2.10? Is it possible that I would see better performance 
> using an earlier rev? 
> 
> I am using v2.10 of QGIS, running on a Win7 HP destop machine, quad core, 8 
> GB RAM. 
> 
> Thanks. 
> 
> ---- 
> Kenneth Walenga 
> Commercial BI & Reporting 
> Genentech, A Member of the Roche Group 
> US CommOps - USMA Data Services 
> "Every moment matters.  Making IT happen." 
> (O) 650-467-6855 
> (F) 650-467-2570 
> (M) 650-438-4505 
> 
> 
> 
> _______________________________________________ 
> Qgis-user mailing list 
> [hidden email] 
> http://lists.osgeo.org/mailman/listinfo/qgis-user 
> 

_______________________________________________
Qgis-user mailing list
[hidden email] 
http://lists.osgeo.org/mailman/listinfo/qgis-user 

		If you reply to this email, your message will be added to the discussion below: 
		http://osgeo-org.1560.x6.nabble.com/Incredibly-slow-performance-using-QGIS-v2-10-tp5221839p5221860.html 

		To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.com 
		To unsubscribe from Quantum GIS - User, click here . 
		NAML 

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Incredibly-slow-performance-using-QGIS-v2-10-tp5221839p5221863.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150830/27542059/attachment.html>