Re: [QGIS-Developer] Why so many database calls?

2023-08-05 Thread Cory Albrecht via QGIS-Developer
So after getting very frustrated with QGIS taking literally hours to simply delete vertices, I made a bug report https://github.com/qgis/QGIS/issues/53973 When doing anything with vertices, QGIS makes the following set of exactly the same (except or the cursor id) SQL queries 1 or more times f

Re: [QGIS-Developer] Why so many database calls?

2023-06-24 Thread Alessandro Pasotti via QGIS-Developer
Hi Cory, I think many developers have one or two ideas about where to look, they probably didn't have the time to look into it. Is there a ticket already? On Sat, Jun 24, 2023 at 8:46 PM Cory Albrecht via QGIS-Developer wrote: > > So, nobody knows why QGIS makes all those seemingly wasteful SQ

Re: [QGIS-Developer] Why so many database calls?

2023-06-24 Thread Cory Albrecht via QGIS-Developer
So, nobody knows why QGIS makes all those seemingly wasteful SQL reads? On Fri, Jun 16, 2023 at 1:18 PM Cory Albrecht wrote: > So QGIS took almost 2.5 hours to delete those 1,000-ish vertices, spitting > out those seemingly unnecessary transaction blocks every second or so. > Judging by the numb

Re: [QGIS-Developer] Why so many database calls?

2023-06-16 Thread Cory Albrecht via QGIS-Developer
So QGIS took almost 2.5 hours to delete those 1,000-ish vertices, spitting out those seemingly unnecessary transaction blocks every second or so. Judging by the numbers of the named blocks, roughly 5,000 of them were done just to delete those 1,000-ish vertices. Right now, on that same feature, I

[QGIS-Developer] Why so many database calls?

2023-06-15 Thread Cory Albrecht via QGIS-Developer
Hello, So I've been trying to track down why my postgresql server was getting so many Signal 10 (SUG BS, memory bus) errors. So far I have figured out that they are only happening when QGIS is connecting to it using GSS/Kerberos encryption. No clue yet as to which side is the culprit (e.g. bad QGI