[QGIS-Developer] db manager SQL console very slow

[i-s-o]

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 <giovanni.manghi at gmail.com>
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
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200709/c07c4dc7/attachment.html>