Postgres Pro
Downloads
Home   >   mailing lists

Thread: SQL editor too slow on remote X

SQL editor too slow on remote X

From
Claudio Freire
Date:
I know this is not a common use case, and you probably don't want to
support it. But I'll open up the e-mail pointing out that I've seen
this exact behavior with local X displays, when they're running slow,
so it would be nice to fix it.

Something on the new SQL editing panel with syntax highlighting is
making it skip key input when it is slow to update. I've noticed it
particularly true on remote X displays (ssh -X -C), which would
indicate it involves communication with the X server.

I would propose a quick way to patch it up, is to delay syntax
highlight processing when input is happening, and only do it when,
say, a timeout without input occurs.

I might be able to work out a patch if given a pointer (where to look
at in the code).

Re: SQL editor too slow on remote X

From
Dave Page
Date:
On Mon, Feb 6, 2012 at 5:47 PM, Claudio Freire <klaussfreire@gmail.com> wrote:
> I know this is not a common use case, and you probably don't want to
> support it. But I'll open up the e-mail pointing out that I've seen
> this exact behavior with local X displays, when they're running slow,
> so it would be nice to fix it.
>
> Something on the new SQL editing panel with syntax highlighting is
> making it skip key input when it is slow to update. I've noticed it
> particularly true on remote X displays (ssh -X -C), which would
> indicate it involves communication with the X server.
>
> I would propose a quick way to patch it up, is to delay syntax
> highlight processing when input is happening, and only do it when,
> say, a timeout without input occurs.
>
> I might be able to work out a patch if given a pointer (where to look
> at in the code).

The highlighting is handled by wxWidgets, so this would almost
certainly need to be patched there.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: SQL editor too slow on remote X

From
Claudio Freire
Date:
On Mon, Feb 6, 2012 at 2:50 PM, Dave Page <dpage@pgadmin.org> wrote:
> The highlighting is handled by wxWidgets, so this would almost
> certainly need to be patched there.

Interesting...

...I'll try disabling it and see if it makes it go away.

In which case, an option to toggle syntax highlighting would be useful.