[Qgis-developer] Disable Syntax Highlighting in DB Manager

[Gino Pirelli]

I can't confirm...

"Try, for example, typing `SELECT 1;` into the window, and see how long it
takes you"

I can't repeat the problems doing this... can you post a better test case?

Luigi Pirelli (luigi.pirelli at faunalia.it)


On 24 November 2013 22:24, Lee Hachadoorian <Lee.Hachadoorian+L at gmail.com>wrote:

> I find the DB Manager SQL window to be unusable, and have confirmed that
> it is because of syntax highlighting by disabling this feature in my
> installation. There is an issue already in the tracker
> https://hub.qgis.org/issues/6995 entitled "db manager's SQL window
> freezes with long query (due to syntax coloring?)". Giuseppe suggests:
>
> > Pasting or editing such a query makes highlighting process slow here,
> but it doesn't freeze (it could depend on resources available on my
> notebook). I could check the query length, but using a 124190 chars query
> long is something not usual anyway...
>
> This is correct in that QGIS does not completely stop responding, but the
> latency is so high as to make the dialog unusable for anything other than
> pasting in an already tested query. Try, for example, typing `SELECT 1;`
> into the window, and see how long it takes you. I'm running QGIS on a Linux
> Mint 13 laptop with an i7 processor and 8GB RAM, so I don't think this has
> anything to do with system resources.
>
> At the moment, I have altered my local version by commenting out lines 34
> and 56 of /usr/share/qgis/python/plugins/db_manager/dlg_sql_window.py. I
> would like to suggest that until some time can be invested in making the
> syntax highlighting functionality usable (if there is even interest in
> doing so for a feature that is just eye candy), that this change be tested
> and incorporated in the official version.
>
> Respectfully and with thanks to those who have created and contributed to
> the DB Manager plugin,
> --Lee
>
>
> --
> Lee Hachadoorian
> Assistant Professor in Geography, Dartmouth College
> http://freecity.commons.gc.cuny.edu
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20131124/bbbb2202/attachment.html>