[Qgis-developer] split features takes a LONG time over network

William Kyngesburye woklist at kyngchaos.com
Mon Jan 28 13:09:35 PST 2013


Arrgghh - now trying to delete one half of the split feature and it's downloading all over again from the postgis server.  jeez, just to delete? I haven't even tried to save yet.

On Jan 28, 2013, at 3:05 PM, William Kyngesburye wrote:

> I'm trying to split a selected line feature in a postgis database on the network (not local machine).  The database layer is almost 4GiB (10M records) and is spatially indexed.
> 
> The feature is selected, it's not very large and I am zoomed to see about half of it.  It took about a half hour to split, and during that time was downloading a constant stream from the postgis server.  I'm guessing it looked at every feature in the database.
> 
> bug? (didn't see anything in the tracker)  lack of optimization?  maybe it was fixed in trunk?  Continuing to edit this database will be impractical as it is in 1.8.
> 
> 
> QGIS 1.8, OS X
> 
> -----
> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
> http://www.kyngchaos.com/
> 
> Theory of the Universe
> 
> There is a theory which states that if ever anyone discovers exactly what the universe is for and why it is here, it will instantly disappear and be replaced by something even more bizarrely inexplicable.  There is another theory which states that this has already happened.
> 
> -Hitchhiker's Guide to the Galaxy 2nd season intro
> 
> 
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer

-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/

First Pogril: Why is life like sticking your head in a bucket filled with hyena offal?
Second Pogril: I don't know.  Why IS life like sticking your head in a bucket filled with hyena offal?
First Pogril: I don't know either.  Wretched, isn't it?

-HitchHiker's Guide to the Galaxy




More information about the Qgis-developer mailing list