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 <[email protected]>: > 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 [email protected] > > -----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----- > > -- Sergio Gollino
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
