Hi Jakob,
I don't think there is much background information or documentation
available on relations.
The obvious questions to you are:
- What means "big" (how many records are you dealing with)?
- I know this sounds silly - but are your tables properly indexed (you
don't have to index primary keys, but other columns that are used in
relations need an index)
- What exact QGIS version are you using? 2.18.x - in the about dialogue
you can find this, including the exact github version string
- if we can't help you further, it may help to see your create table
statements (including all indexes)
Andreas
On 03.08.2017 11:47, Jakob Miksch wrote:
Hello,
I have a (rather big) Postgres/PostGIS database that basically looks
like this: https://ibb.co/bK7PKv
I want to use QGIS for editing and inserting data.
I already found these ressources:
https://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/vector_properties.html#fields-properties
https://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/attribute_table.html#creating-one-or-many-to-many-relations
https://docs.qgis.org/2.18/en/docs/training_manual/create_vector_data/forms.html
I tried it: I created the relations and built custom forms.
However, when I want to insert or edit something. QGIS becomes really
slow and crashes finally. But before I describe the problems in more
detail I want to read more about it. I find the documentation (linked
above) a bit too little.
So, my question:
Is there any documentation I have missed?
Is there any book (chapter) you can recommend?
Do you know of any example where QGIS is used for entering data into
many related tables in Postgres/PostGIS at once?
I am thankful for any hint or resource.
Jakob
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user