[Qgis-developer] QGIS indexing data when editing

[Denis Rouzaud]

On 08/13/2015 12:12 PM, Vincent Picavet (ml) wrote:
> Hello,
>
> 30s freeze is something which seems rather unpleasant for the user.
I am not experiencing such freeze. With a project with ~100 layers, with 
10 having more than 10k features, I have something around 2 to 3 seconds.
I beleive this is reasonable.
>
> Could we imagine to do the indexing in background ?
Indexing is started when an editing map tools (or I believe any snapping 
operation) is enabled.
Since it is required on mouse events, it needs to freeze the app in the 
mean time.
>
> And maybe indexing only what is currently in the user's extent, if this
> is not what is currently done ?
Would be an idea, although I am not sure this is really required. Nobody 
complained very much yet about this.
Martin would have to answer for saying if it's feasible or not.
>
> Indexing a whole layer for editing seems a no-go. We should maybe have a
> way to get the user to use the indexing tools only when zoomed in ?
>
> Vincent
>
> On 13/08/2015 07:38, Denis Rouzaud wrote:
>> Dear Nicolas,
>>
>> The indexing is used for snapping in the application.
>> It takes a few sec when enable the first tool, but snapping is much
>> faster later on.
>>
>> Best wishes,
>> Denis
>>
>> On 08/12/2015 02:30 PM, Doctor Who wrote:
>>> Hello,
>>>
>>> I'm using QGIS 2.10.1 and 2.8.3 with PostGreSQL 9.3 and PostGIS 2.5 under
>>> Linux openSUSE 13.2 64bits.
>>> A strange things appear since i've move from PostGreSQL 9.1 -> 9.3
>>>
>>> Each time I open a layer for editing, when I selected any tools (node
>>> tools
>>> or creation entity tools), QGIS freeze about 30 sec and display 'indexing
>>> data' progress bar. (memory of my computer grow up in same time)
>>> After that, I could editing my data, close it and reopen editing session
>>> whithout any problem or any crash.
>>> But if I close my project and reopen it, again indexing data when I
>>> want to
>>> edit a layer.
>>>
>>> I've seen that new thing under a small layer (90 entities) and bigger one
>>> (about 250 000 objects), same things for Polygon or Point geometry.
>>> I've a primary key constraint and a spatial index.
>>>
>>> Have you already see that somewhere else ? I can't find why as it never
>>> happens before.
>>>
>>> Best regards,
>>>
>>> Nicolas
>>>
>>>
>>>
>>> -----
>>> -- 
>>>
>>> GIS administrator in Urban Agency of the Greater Amiens
>>>
>>> Founder and main administrator of forumSIG
>>>
>>>    --
>>> View this message in context:
>>> http://osgeo-org.1560.x6.nabble.com/QGIS-indexing-data-when-editing-tp5219525.html
>>>
>>> Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.
>>> _______________________________________________
>>> Qgis-developer mailing list
>>> Qgis-developer at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer