11M Points layer so it takes a
while .
*From: *Régis Haubourg
*Date: *Saturday, 25 June 2022 at 12:54
*To: *Rémi Desgrange
*Cc: *QGIS Developers List
*Subject: *Re: [QGIS-Developer] Feature count for DB provider.
Hi Rémy, There had been a lot of work for postGIS and oracle
providers. A coun
e a 11M Points layer so it takes a while .
From: Régis Haubourg
Date: Saturday, 25 June 2022 at 12:54
To: Rémi Desgrange
Cc: QGIS Developers List
Subject: Re: [QGIS-Developer] Feature count for DB provider.
Hi Rémy, There had been a lot of work for postGIS and oracle providers. A
count(*) might
Hi Rémy, There had been a lot of work for postGIS and oracle providers. A
count(*) might be really expensive for big tables, so there are options to
use db statistics instead of real count. I bet the loop you point out
occurs only in fallback situations but is not the main case.
One is here for
Hi,
Just launched the new QGIS 3.24, and tests the SQL debugger, I just found out
that the “feature count” does a while loop on all features in the layer to
count.
While it’s probably necessary for shapefiles or stuff like that, it appears
suboptimal for databases access. I found this part in