1. General
  2. Errores
+44
Solucionado

Better handling of huge files

n00ge hace 14 años • actualizado por Jon Skinner hace 12 años • 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?

Respuesta

Respuesta
Solucionado
Jon Skinner hace 13 años

This was fixed in 2091.


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

+2
Toby Evans hace 13 años

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

+2
Jon Skinner hace 13 años

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

Respuesta
Solucionado
Jon Skinner hace 13 años

This was fixed in 2091.


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

Josh Benner hace 13 años
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 hace 12 años
I noticed that big files are better handled in the 64-bit version of Sublime
Paul-Sebastian Manole hace 12 años
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 hace 12 años

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 hace 12 años

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 hace 12 años

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

+1
Andras hace 12 años

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)

Servicio de atención al cliente por UserEcho