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

[Vincent Picavet]

Hi William,

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

Do you have a primary key defined on your PostGIS table ?

Vincent

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