Timeline for Query in QGIS is significantly slower, than in pgAdmin
Current License: CC BY-SA 4.0
22 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 19, 2021 at 19:49 | answer | added | Luis Perez | timeline score: 0 | |
| May 26, 2021 at 3:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 25, 2021 at 10:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 25, 2020 at 6:00 | history | tweeted | twitter.com/StackGIS/status/1309372071772860418 | ||
| Sep 24, 2020 at 21:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 27, 2020 at 16:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 23, 2020 at 20:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 24, 2019 at 8:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 28, 2019 at 11:28 | comment | added | Maximilien jaffrès | we made some utilities in python, for exemple we have a class SettingProperties which handle currentdbname, user , password. This class can be setup with a JSONsetting file stored in the user's directory. We also have class to create a Project which gather these informations. | |
| Aug 28, 2019 at 10:06 | comment | added | DIV | @Maximilienjaffrès and how do you deal with credentials (storing, etc.)? | |
| Aug 22, 2019 at 13:48 | history | edited | DIV | CC BY-SA 4.0 |
added 1 character in body
|
| Aug 22, 2019 at 12:58 | history | edited | DIV | CC BY-SA 4.0 |
added 50 characters in body
|
| Aug 22, 2019 at 12:53 | answer | added | Joseph | timeline score: 1 | |
| Aug 22, 2019 at 12:33 | comment | added | DavidP | Typically, DB administration tools (like pgAdmin) fetches only a subset of rows for each query (200 or so). QGIS fetches all of them in your example. That can make a huge difference on tables with large row counts... | |
| Aug 22, 2019 at 12:30 | comment | added | DIV | @Joseph I acknowledge that, but I tested something as well. I've used same table, but without that join. And weirdly, QGIS run query almost as fast as pgAdmin. Do you think that a table joining might be too much for QGIS in general? | |
| Aug 22, 2019 at 12:25 | comment | added | Maximilien jaffrès | I also make a Python plugin in Qgis. And by my experience, we always ask PostgreSQL to perform queries because native Qgis is doomed to be slow, sorry. | |
| Aug 22, 2019 at 12:23 | history | edited | Vince | CC BY-SA 4.0 |
naming
|
| Aug 22, 2019 at 12:19 | comment | added | DIV | @Maximilienjaffrès I've used psycopg2 in the plugin as well, but in this case is much more easier to use QGIS's layer. It's connected to permissions, logging, etc. and I want to avoid that. But If QGIS's slowness is 'normal', than I have to change my mind I guess. | |
| Aug 22, 2019 at 12:07 | comment | added | Maximilien jaffrès | Generally speaking, Qgis is not super fast for huge query I would say. If you have Postgressql and you want to script things in python. why don't you use the SGBD to perform your query ? You can try with psycopg2 : wiki.postgresql.org/wiki/Psycopg2_Tutorial | |
| Aug 22, 2019 at 12:07 | comment | added | Joseph | PostgreSQL is a dedicated database management system which specialises in such queries. QGIS is not - so there will always be a performance gap. | |
| Aug 22, 2019 at 12:03 | history | edited | DIV | CC BY-SA 4.0 |
edited tags
|
| Aug 22, 2019 at 11:58 | history | asked | DIV | CC BY-SA 4.0 |