#524 Slow on long line query

2.5
open
5
2007-07-05
2007-06-28
Anonymous
No

When you try to move to the end or to top the beginning of a very long query line in SQL editor, the application keep stucked for many seconds.

Bug tested both in Windows as in Linux, with many L&F.

Application runned with jdk1.6.0_01-b06

Discussion

  • Rob Manning

    Rob Manning - 2007-07-05

    Logged In: YES
    user_id=1287991
    Originator: NO

    I have seen this behavior before when I was looking at how to solve the memory problem for large scripts:

    http://sourceforge.net/tracker/index.php?func=detail&aid=1686698&group_id=28383&atid=393414

    We do alot of work in the editor with regard to syntax highlighting. Previously when I profiled it the culprit seemed to be Character.isUpperCase, and I made several unsuccessful attempts to fix it. You may be able to speed up the editing of long lines by using the plain editor instead of NetBeans - but what a cost! Also, if you format your SQL statement (Ctrl-Alt-f) it may reduce the length of the line enough that you don't notice the problem as much. The time it takes to traverse the line increases (seemingly geometrically) as the length increases.

    Rob

     
  • Rob Manning

    Rob Manning - 2007-07-05
    • labels: 465987 --> Syntax Highlighting plugin
     
  • Bron Eubanks

    Bron Eubanks - 2007-07-27

    Logged In: YES
    user_id=1842742
    Originator: NO

    When it gets stuck, is the CPU idle or maxed out?

     
  • Nobody/Anonymous

    Logged In: NO

    Strange. The initial open operation was almost instantaneous on my laptop, but the CPU then went to and stayed at 100% until I closed Squirrel. (Also, cursor movements were then slow.)

    Bron

     
  • EkriirkE

    EkriirkE - 2007-11-12

    Logged In: YES
    user_id=1580241
    Originator: NO

    I, too, get this problem. It also occurs when I Ctrl+Click a table that doesn't exist to locate it in the object browser.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks