[QGIS-trac] [Quantum GIS] #3315: editing the attribute table POSTGIS in QGis via VPN

[Quantum GIS]

#3315: editing the attribute table POSTGIS in QGis via VPN
------------------------------------------------+---------------------------
   Reporter:  jcnotter                          |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.7.0
  Component:  Build/Install                     |            Version:  1.6.0        
   Keywords:  postgis                           |   Platform_version:               
   Platform:  Windows                           |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 When editing the attribute table  POSTGIS in QGis via VPN, in the POSTGRES
 logs :

 Dec 6 10:36:05 bdd postgres[18859]: [284-1] 2010-12-06 10:36:05 UTC LOG:
 duration: 0.317 ms statement: declare qgisfid0 binary cursor for select
 "gid","N_"::text,"N__DE_L_OB"::text,"DONN__ES_P"::text,"PNRUN_AUTR"::text,"NOM_D_COUV"::text,"NOM_S__OBS"::text,"DATE_D_OBS"::text,"DATE_IMPR_"::text,"HEURE_D_OB"::text,"UTMX"::text,"UTMY"::text,"COMMUNE"::text,"LIEU_DIT"::text,"N__SUR_LA_"::text,"SOLEIL__NU"::text,"MILIEU"::text,"ESP_CE"::text,"ADULTE_M_L"::text,"ADULTE_FEM"::text,"JUV_NILE"::text,"SEXE___GE_"::text,"REMARQUES_"::text,"R_DACTEUR_"::text,"VALIDEUR_S"::text,"VALIDEUR_2"::text
 from "public"."phelbor" where "gid"=35 Dec 6 10:36:05 bdd postgres[18859]:
 [285-1] 2010-12-06 10:36:05 UTC LOG: duration: 0.099 ms statement: fetch
 forward 1 from qgisfid0 Dec 6 10:36:05 bdd postgres[18859]: [286-1]
 2010-12-06 10:36:05 UTC LOG: duration: 0.027 ms statement: CLOSE qgisfid0
 Dec 6 10:36:05 bdd postgres[18859]: [287-1] 2010-12-06 10:36:05 UTC LOG:
 duration: 0.026 ms statement: COMMIT

 This represents a transaction and there is one for each line. That is very
 slow !.

 => If you add up all the times, we get 0491 ms for this, ie, it calculates
 two lines in one second

 => If the file has 120 lines ... it will take 1 min and 1200 lines for 10
 minutes …

 it's too long

 (If I use pgAdmin, it works well)

 I think it's too difficult to work with QGis in this case

 Thank you...

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/3315>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats