1. General
  2. Bugs
+44
Fixed

Better handling of huge files

n00ge 14 years ago • updated by Jon Skinner 12 years ago • 9
When handling large sql files (25k lines and up) it takes a while (12 seconds+) to open the file and manipulate. Editing is also quite slow.

I'm not expecting miracles, but is there anything that can be done here? Maybe look at the file size and don't apply syntax highlighting initially for x mb size files and up?

Answer

Answer
Fixed
Jon Skinner 13 years ago

This was fixed in 2091.


The SQL grammar file had a degenerate regex that could cause significant slowdowns.

+2
Toby Evans 13 years ago

I agree, even files of about 5000 lines start to slow down considerably.

+2
Jon Skinner 13 years ago

 5000 line files are, in general, handled fine. Check what plugins you have installed - several can cause severe slow downs.

Answer
Fixed
Jon Skinner 13 years ago

This was fixed in 2091.


The SQL grammar file had a degenerate regex that could cause significant slowdowns.

Josh Benner 13 years ago
Sublime Text 2 just took about 2 minutes to open a 9.5MB SQL file (build 2111). Find and replace in this file is taking ages.
Holger Ludvigsen 12 years ago
I noticed that big files are better handled in the 64-bit version of Sublime
Paul-Sebastian Manole 12 years ago
I have the unregistered Version 2.0.1, Build 2217 and a 1642 lines XML file loaded in one tab and a 2150 lines XML file in another tab. Scrolling and moving the cursor around, editing and just maybe every graphical change in the tab with the larger file is 2 to 3 times slower, feeling sluggish. It's easy to see that if you keep pressing the Right Arrow key, it moves faster in the slower file compared to the larger one. So I guess this is a graphical sybsystem problem.  Maybe the graphical buffer is too large for it to be changed at every edit in a snappy fashion.
+4
Shawn McCool 12 years ago

Loading a 94meg SQL file can take upwards of 10 minutes on a reasonably powerful laptop. I'd like to see some sort of memory paging implemented.

+1
Bo Liao 12 years ago

I'd like to see the option that would turn off syntax highlights automatically when opening files over a specified size, identical to the already present "auto_complete_size_limit" option.

It would speed up the process by a LOT, and I assume it would be trivial to implement.

Martin Caminoa Lizarralde 12 years ago

 I'd like to see this feature to open +800mb SQL files in seconds like I already do with gVim

+1
Andras 12 years ago

This is basically the same request as the: "Use memory mapped files for opening and viewing large files (e.g. 1GB+)"


Would be very useful for a lot of people who are working with large files. (or course the search function need to be tweaked for this)

Customer support service by UserEcho