+44
FIXED
posted by N00ge , updated 1 year 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?
Vote

Answer

ANSWER
FIXED

This was fixed in 2091.


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

+1

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

+2

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

ANSWER
FIXED

This was fixed in 2091.


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

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.
I noticed that big files are better handled in the 64-bit version of Sublime
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.
+2

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.

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.

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

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)