I had run into a similar issue. In my case, adding "LIMIT 500000" to my query fixed the speed issue (I had fewer than 500k rows). Looked like a bug in my opinion, but I didn't have time to investigate further (I think it was a gpkg).
i-s-o On Wed, Jul 8, 2020, 10:29 Giovanni Manghi <[email protected]> wrote: > Hi all, > > Has anyone noticed how slow the DB Manager SQL console is? > > It is not just a matter of slowness when returning (on screen) a lot > of results, it is very slow even when issuing a query like: > > SELECT count(*) FROM mytable; > > I did a few quick tests and compared to other consoles (i.e. pgadmin, > dbeaver, psql) and it is about 15/20 times slower. > > Any idea about the possible cause? > > cheers > > -- G -- > _______________________________________________ > QGIS-Developer mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
