Re: [Qgis-user] Problem with add postgis layers in qgis 1.80
On Thu, 2012-07-19 at 07:14 +0200, siegfried.bl...@lazbw.bwl.de wrote: Hallo ‚add postgis layers“ is very, very slowly in qgis 1.80 when I have many tables. It needs several (up to 10) minutes until all tables where “detecting” every time when I want add a postgis layer. Thanks for tricky tips to make it faster! Hi, I have DB with 1+ tables (no views for now) in it and many different schemas, and the table list shows in a just 2/3 seconds. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problem with add postgis layers in qgis 1.80
Am 19.07.12 10:09, schrieb Giovanni Manghi: On Thu, 2012-07-19 at 07:14 +0200, siegfried.bl...@lazbw.bwl.de wrote: Hallo ‚add postgis layers“ is very, very slowly in qgis 1.80 when I have many tables. It needs several (up to 10) minutes until all tables where “detecting” every time when I want add a postgis layer. Thanks for tricky tips to make it faster! Hi, I have DB with 1+ tables (no views for now) in it and many different schemas, and the table list shows in a just 2/3 seconds. Not quiet the same for me: I use a postgis database with openstreetmap data of my region. The table for (multi-)polygons takes a lot of time to detect the type of elements. Only one table, but lots of elements in there (one for every building...) Greetings, Andre Joost ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problem with add postgis layers in qgis 1.80
Not quiet the same for me: I use a postgis database with openstreetmap data of my region. The table for (multi-)polygons takes a lot of time to detect the type of elements. Only one table, but lots of elements in there (one for every building...) In that DB I have also all the layers (streets, buildings, etc.) from OSM and no such problem... not sure where the issue can be. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problem with add postgis layers in qgis 1.80
Hi Siegfried, On Thu, 19. Jul 2012 at 07:14:31 +0200, siegfried.bl...@lazbw.bwl.de wrote: 'add postgis layers is very, very slowly in qgis 1.80 when I have many tables. It needs several (up to 10) minutes until all tables where detecting every time when I want add a postgis layer. Check if your tables are in geometry_columns. If not QGIS needs to determine which geometry types are in table. You can also use the use estimated metadata in the connection settings to let qgis check only a few rows in the tables which are not listed geometry_columns instead of all rows. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de committ(ed|ing) to Quantum GIS IRC: jef on FreeNode -- norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problem with add postgis layers in qgis 1.80
Am 19.07.2012 10:55, schrieb Jürgen E. Fischer: Hi Siegfried, On Thu, 19. Jul 2012 at 07:14:31 +0200, siegfried.bl...@lazbw.bwl.de wrote: 'add postgis layers is very, very slowly in qgis 1.80 when I have many tables. It needs several (up to 10) minutes until all tables where detecting every time when I want add a postgis layer. Check if your tables are in geometry_columns. If not QGIS needs to determine which geometry types are in table. You can also use the use estimated metadata in the connection settings to let qgis check only a few rows in the tables which are not listed geometry_columns instead of all rows. Jürgen sorry for the fuzz, I had the metadata tickbox checke in my 1.7 install it is considerably faster with that setting in 1.8, too Bernhard __ Information from ESET Mail Security, version of virus signature database 7311 (20120719) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problem with add postgis layers in qgis 1.80
but the add button stays inactive until the type for all layers has been detected (which is faster when using the estimated metadata but still takes some 10 seconds in my case) Bernhard Am 19.07.2012 11:05, schrieb Bernhard Ströbl: Am 19.07.2012 10:55, schrieb Jürgen E. Fischer: Hi Siegfried, On Thu, 19. Jul 2012 at 07:14:31 +0200, siegfried.bl...@lazbw.bwl.de wrote: 'add postgis layers is very, very slowly in qgis 1.80 when I have many tables. It needs several (up to 10) minutes until all tables where detecting every time when I want add a postgis layer. Check if your tables are in geometry_columns. If not QGIS needs to determine which geometry types are in table. You can also use the use estimated metadata in the connection settings to let qgis check only a few rows in the tables which are not listed geometry_columns instead of all rows. Jürgen sorry for the fuzz, I had the metadata tickbox checke in my 1.7 install it is considerably faster with that setting in 1.8, too Bernhard __ Information from ESET Mail Security, version of virus signature database 7311 (20120719) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user __ Information from ESET Mail Security, version of virus signature database 7311 (20120719) __ The message was checked by ESET Mail Security. http://www.eset.com -- Bernhard Ströbl Anwendungsbetreuer GIS Kommunale Immobilien Jena Am Anger 26 07743 Jena Tel.: 03641 49- 5190 E-Mail: bernhard.stro...@jena.de Internet: www.kij.de Kommunale Immobilien Jena Eigenbetrieb der Stadt Jena Werkleiter: Thomas Dirkes __ Information from ESET Mail Security, version of virus signature database 7311 (20120719) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problem with add postgis layers in qgis 1.80
Hi Bernhard,
On Thu, 19. Jul 2012 at 11:01:24 +0200, Bernhard Ströbl wrote:
Therefore QGIS 1.7.4 loads the view with an sql-query e.g.
upper(geometrytype(the_geom)) IN ('POLYGON','MULTIPOLYGON') whereas
1.8 does not. So 1.7 only checked 100 features and detected their
geometry type and made sure that only fitting types are loaded by
setting an appropriate query.
You checked use estimated metadata in 1.7, but apparently not in 1.8.
Also QGIS 1.7 offered the possibility to already open a schema while
still detecting. The type said waiting for the views in question but
you could nevertheless load a layer where the geometry type was already
detected (e.g. because it is registered in geometry_columns).
The detection is now done in a thread, so you can cancel the detection.
Jürgen
--
Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13Fax. +49-4931-918175-50
Software Engineer D-26506 Norden http://www.norbit.de
committ(ed|ing) to Quantum GIS IRC: jef on FreeNode
--
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problem with add postgis layers in qgis 1.80
Hi Jürgen,
Am 19.07.2012 11:15, schrieb Jürgen E. Fischer:
Hi Bernhard,
On Thu, 19. Jul 2012 at 11:01:24 +0200, Bernhard Ströbl wrote:
Therefore QGIS 1.7.4 loads the view with an sql-query e.g.
upper(geometrytype(the_geom)) IN ('POLYGON','MULTIPOLYGON') whereas
1.8 does not. So 1.7 only checked 100 features and detected their
geometry type and made sure that only fitting types are loaded by
setting an appropriate query.
You checked use estimated metadata in 1.7, but apparently not in 1.8.
I already realized that (see the post before my last post)
Also QGIS 1.7 offered the possibility to already open a schema while
still detecting. The type said waiting for the views in question but
you could nevertheless load a layer where the geometry type was already
detected (e.g. because it is registered in geometry_columns).
The detection is now done in a thread, so you can cancel the detection.
also as a user - how?
Bernhard
__ Information from ESET Mail Security, version of virus signature
database 7311 (20120719) __
The message was checked by ESET Mail Security.
http://www.eset.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Problem with add postgis layers in qgis 1.80
Hallo 'add postgis layers is very, very slowly in qgis 1.80 when I have many tables. It needs several (up to 10) minutes until all tables where detecting every time when I want add a postgis layer. Thanks for tricky tips to make it faster! Siegfried Blank Landwirtschaftliches Zentrum für Rinderhaltung, Grünlandwirtschaft, Milchwirtschaft, Wild und Fischerei Baden-Württemberg (LAZBW) Fischereiforschungsstelle Baden-Württemberg (Fisheries Research Station) Argenweg 50/1 88085 Langenargen Tel.: 0049-(0)7543-9308313 Fax: 0049-(0)7543-9308320 (Germany) http://www.lazbw.de http://www.lazbw.de/ --- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
