This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 136539 - Editor is not responsive for large .sql files
Summary: Editor is not responsive for large .sql files
Alias: None
Product: editor
Classification: Unclassified
Component: Painting & Printing (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: issues@editor
Depends on: 121357
  Show dependency tree
Reported: 2008-06-05 10:47 UTC by Petr Jiricka
Modified: 2008-06-09 11:18 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Thread dump (15.01 KB, text/plain)
2008-06-05 14:20 UTC, Andrei Badea
Attaching the file in a zip file. The longest line in the file is >200,000 characters. (654.85 KB, application/octet-stream)
2008-06-07 22:30 UTC, Petr Jiricka

Note You need to log in before you can comment on or make changes to this bug.
Description Petr Jiricka 2008-06-05 10:47:48 UTC
1. Download the Sakila db sample from the mysql website
2. Open the sakila-data.sql file in the editor

=> The editor is not responsive, scrolling is very slow.
Comment 1 Andrei Badea 2008-06-05 14:20:34 UTC
Created attachment 62410 [details]
Thread dump
Comment 2 Andrei Badea 2008-06-05 14:21:51 UTC
All thread dumps I took show the editor being busy drawing.
Comment 3 Andrei Badea 2008-06-05 16:49:40 UTC
By the way, the file I and the reporter tested with has very long lines, perhaps that could be the cause.
Comment 4 Vitezslav Stejskal 2008-06-07 12:35:33 UTC
The new view hierarchy will hopefully perform better. How long lines are we talking? Could you attach sakila-data.sql
here (perhaps in a .zip form)? Thanks
Comment 5 Petr Jiricka 2008-06-07 22:30:48 UTC
Created attachment 62528 [details]
Attaching the file in a zip file. The longest line in the file is >200,000 characters.
Comment 6 Vitezslav Stejskal 2008-06-09 11:18:41 UTC
Oh well, that's it then. I opened sakila-data.sql and although the editor was sluggish it seemed to handle the file
quite well. The longest line I found was 1.032.623 characters long. I pasted it to OpenOffice and it created 338 pages
of text, the number of characters is from the document statistics. GEdit didn't even render a line like this for
example. Anyway, the editor with current view hierarchy can handle seamlessly lines with ~100k characters (see issue
#114016), which IMO is beyond any practical use. The new hierarchy should perform even better, but the task hasn't made
it to any schedule yet.