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

[Ken Walenga]

I have replied to your questions in-line, below:

On Sun, Aug 30, 2015 at 11:03 AM, Alex Mandel <tech_dev at wildintellect.com>
wrote:

> 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.

>
> Are you joining the SHP and the CSV and then doing Dissolve?

Yes.

> Did you
> save the joined layer to a new file?

Yes

> Does this shapefile have a spatial
> index created?

Yes

> 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.

>
> 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?

>
> 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
> > Qgis-user at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150830/cdb86e85/attachment.html>