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

[William Kyngesburye]

Some more info: editing attributes in the attributes table is fast, even in quick succession, but applying a field calculator to a selection again appears to be downloading the whole table.

In all cases (today's and original issue) saving changes back to the database is fast.

On Jan 28, 2013, at 4:23 PM, William Kyngesburye wrote:

> On Jan 28, 2013, at 4:10 PM, Vincent Picavet wrote:
> 
>> 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 ?
>> 
> yes
> 
>> 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/

"I ache, therefore I am.  Or in my case - I am, therefore I ache."

- Marvin