Lag between pressing a key and seeing it on the screen

Lag between pressing a key and seeing it on the screen

Follow / 12 Jan 2012 at 6:57pm
A few of us started having this problem a few weeks ago.  It comes and goes, but is present more than it is not.    SQL Navigator Professional Edition 6.4.0.1930.

There is usually a lag between pressing a keyboard key and when the key appears on the screen.  You can type an entire query and nothing appears on the screen until 2-5 seconds after you stop typing.  The more you type, the longer the lag.

We haven't been able to figure out what triggers the behavior.  Sometimes SQL Navigator will show the behavior as soon as it starts, other times it suddenly starts.  We use SQL Navigator for an Oracle 10 database and an Oracle 11 database and we have the problem with both databases.

Restarting SQL Navigator does not solve the problem.  Reinstalling SQL Navigator likewise doesn't help.  Upgrading is not going to happen any time soon.  Any ideas?

Replies

  • Follow / 13 Jan 2012 at 1:16am
    Hi John,

    We believe your issue is the same as Andres reported with v6.4 a while ago where SQL Navigator runs the sql to check debug info for -
    http://sqlnavigator.inside.quest.com/thread.jspa?threadID=31748

    This issue has been fixed since v6.5. Hope that you could upgrade to the current version 6.6.

    You can confirm if your issue relates to the debug info statement. Please start the SQL Tracker which can be found in the same program group of SQL Navigator and check if you see many of the following sql in the log for every key stroke:

    BEGIN
    SELECT debuginfo
    INTO :result
    FROM sys.all_probe_objects
    WHERE owner = :owner
    AND object_name = :name
    AND object_type = :type
    AND status = 'VALID';
    END;

    Thanks,
    Bruce