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

[Andreas Neumann]

I agree - you have to put scale constraints in the symbology of an
address table with 20 million records. Displaying all at once wouldn't
make any sense. Most likely, every pixel of your screen would be covered
if you want to display them all.

On our cadastral map with only a couple thousand of address points we
display house numbers from scale 2000 - otherwise you would have too
many labels and the map gets illegible.

Andreas

Am 20.05.2014 11:46, schrieb Sergio Gollino:
> Ok 20 milion of records is the problem not the unique key...
> 
> Create a table (not a view) and use indices and geometry constraints. Check
> the "Use estimated table metadata" option in the connection as Jurgen said.
> Use a field of the table to filter it before you load on qgis.
> And load it when you are a scale like 10.000 or less.
> If this is not enough you have to make tiles of you your table.
> 
> Remember that if you have a shp file whit 20 milion of geometries probably
> you will wait for all your life to display it, so, 5 or 10 minutes, its a
> really good result.
> 
> 
> 2014-05-20 12:44 GMT+02:00 Florian Lohoff <f at zz.de>:
> 
>> On Tue, May 20, 2014 at 12:27:31PM +0200, Sergio Gollino wrote:
>>> Hi Florian,
>>> if you just need a primary key on your view you can add this on your
>> view:
>>>
>>> CREATE OR REPLACE VIEW v_kvztallength_pos AS
>>>  SELECT
>>> row_number() OVER (ORDER BY tablename.id) AS gid,
>>> ecc...
>>> ecc.. .
>>> FROM tablename
>>
>> I'll try that - my first guess is thats it not faster ;)
>>
>>> This create a column with a unique value (gid) that Qgis will recognize.
>>
>>> you can choose the unique key in the table tree when you add your view in
>>> qgis. see -->http://i.stack.imgur.com/Da0xP.png
>>>
>>> but I'm not sure that your problem is here, how many rows have your view?
>>
>> About 20 Million IIRC - And i have told qgis what the unique key is.
>> My datasource has:
>>
>> [...] key='id' srid=4326 type=POINT table="public"."v_kvztallength_pos"
>> (position) sql=
>>
>>> If I have understand it right, you want to edit your view, but you can't
>>> (in an easy way) edit a view even if you have a primary key. Its better
>> for
>>> you to create a table and use spatial indices.
>>
>> I dont need to edit the view i just want to display it.
>>
>> Its basically a join over an address (with geocoded position) with metadata
>> in a different table. The metadata references the address with a foreign
>> key.
>>
>> Flo
>> --
>> Florian Lohoff                                                 f at zz.de
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.10 (GNU/Linux)
>>
>> iQIVAwUBU3syGZDdQSDLCfIvAQiy0hAAkAV1q1SVRHwFv/N9LpPcS/GzB+1Fgo2p
>> +lkoyQkjk2zUHzmrVFhZaAZTvMd8VWGjRXHv9+qwaUX6EAzrNDE0jkZ73YZc+wTl
>> zCAQjmlUICZM1MjfcMTC04jFHALzgHZ0DBeXNi4qW4idqBRmiyIrRam/OFBs3eqe
>> KQHYzomdERXTUct72OnoBIQ/JN9r6xtSn29yjJO8QkiYF1Uph2LV5YHVsZOQJtTt
>> QO3DIoce+tyaSKbwKHk3p4DxEIP2V+puSuQzTW8eMJG/y8Nmr1P4JeBQ1TZ/dpUt
>> RzSEN5uxUAmy4GRukCMgnHqxEXEsiVElvUzSrpiRDAW4HA4f+nU6ZVPnpERvDo/0
>> 9CajTEsYVAEl7iws6/hajgDd0KcFS8TXRZ8WmrG+yjrPS2BgwkXBoo+gEVvRQyPz
>> KZZzawD2YDjkPrV64WumGp1DizqHPPHNI76si8N61qFhVSp0QQUCYSGfVSXL2CbJ
>> x/g63ya8GRNFvHX8QXOqpMyXuEBvWZY/U3AvwzbmoxyWCKR9lxGv7gqacz4U5BFL
>> ypxqVwQ/qRSJvp7GTu9uD9luqpwTTfNynUk56LEfxIWhwwg0mklveDZ4MdII04Jp
>> KXSzpn7lWudTRmz2QqSFjZZiNh5T1TeAd3ejDOeBmblsYNhzLHWLcxeZvqPDNyhS
>> 3CcMhu4zniw=
>> =TMEp
>> -----END PGP SIGNATURE-----
>>
>>
> 
> 
> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>