[Qgis-user] QGis checks uniqueness of primary key on startup

[Andreas Neumann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Florian,

We got it - your problem is only with the initial load of the layer.

Did you try with QGIS 2.2 or QGIS master to see if the problem
persists? If so, this should really be fixed somehow.

Andreas

> 2014-05-20 12:13:56 UTC LOG:  duration: 147171.357 ms  statement:
SELECT count(distinct "id")=count("id") FROM "public"."v_kvztallength_pos"
> 2014-05-20 12:16:23 UTC LOG:  duration: 147145.301 ms  statement:
> SELECT st_extent("position") FROM "public"."v_kvztallength_pos"
> 
> But THIS is not fetching objects for display - this is
> initialization of the layer.
> 
> As you can see its 5 Minutes just for THIS single layer although on
> this startup there was no element/object in the viewport on startup
> at scale 1:8000.
> 
> flo
> 
> 
> 
> _______________________________________________ Qgis-user mailing
> list Qgis-user at lists.osgeo.org 
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJTe0wGAAoJELiCsGDopvBC63AH/3GjpSz9q2MYMKfIPFnLvy68
Sy3RbZCSgD+jHa11hQfVcPtuwsjkuKHvLH5r+1AeaGiWKgXSoWRsvR1rTPbdAv2w
U6gVrDVSpO+c4ZS9ZuKSU/Rki8/zrDJajG6Zbz9P8umyJGojTpLoz8XTDJElUZV3
zLxEp2LaFy2bXePvqJjzhxjqtT2CTmfWfssJwk+swJe1cyh57TdtD2is8DlkCHt1
/fzjbJ+WN698l5SgVd07LvVoFxrPg4vesGRvGocnJ+kQv12djmhMzU4E3F02xdqY
Chs2F6iDtw/T0UrRT9sDsVQX+dwsGeFM1KYpL/ETCOvh5sSQBgTdqLxQI3T86UA=
=g4fr
-----END PGP SIGNATURE-----