Sublime Forum

Accessing files with more than 200k lines

#1

I know this seems stupid, but currently because I am doing SQL work with scripts, I have to edit scripts with more than 200k lines, and because of the amount lines, sublime text 3 freezes up and lags everytime I try to edit the file, especially when I try to edit alot of lines in the file. Is there a solution like some kind of async plugin or something that allows me to read/edit this file with too many lines?

0 Likes
#2

Have you tried to disable indexing?

0 Likes
#3

As a general rule, Sublime Text will handle SQL files with 200k lines with no problem. If you’re seeing slow downs, it’s likely one of:

  • You have extremely long lines
  • You have a 3rd party SQL syntax rather than the default one that comes with Sublime Text
  • You are using a plugin that’s doing something in the background

Best option, assuming you’re on Windows, is to download the Sublime Text 3 portable version, and open the file in that, to see how things are without any customisations.

FWIW file indexing shouldn’t be related to this, as files over 4MB aren’t indexed.

3 Likes
#4

Thanks for the tips, I will download the portable version and see if that fixes the issue and reply later.

0 Likes