I've long had this issue where opening large files, typically MySQL files as they get large quite quickly, but applications bundled with Windows, such as notepad and wordpad just don't cut it - I think because they read the entire file to memory before opening. Even Zend Studio is slow at opening it because it tries to add all of its fancy formatting to the MySQL document to prettify it.

Karl had the issue the other day where he wanted to open a large MySQL file, which was only around 11 megabytes, but although notepad opened it, it soon crashed when you scrolled down, and wordpad gave us a percent loaded but when it got to 100% it simply said something like "Formatting..." which we didn't wait around to see complete.

So I had myself a browse around the Internet to see what applicaions were good at opening very large MySQL files. I came across Scintilla's SCiTE which somebody had remarked on their observation that opening a ~100mb MySQL file in SCiTE took mere seconds. I didn't think that was at all possible, but I downloaded it anyway, and sure enough, SCiTE had loaded in the 11mb MySQL file, with colours as well, in a second at the very longest.

Very impressive stuff! And as I was so impressed, I decided to take a tour and found that it supports syntax highlighting in all the popular programming languages, as well as many I've never before heard of. It even has code collapsing as standard.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

yea its a pretty cool editor, i use it when im on my debian computer.

__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)

I'll try it out tomorrow at work on my openSUSE 10.3 box.

It's not free and Windows only, but UltraEdit is also very good at opening VERY large files.

http://www.ultraedit.com/

Mubs

Why not try Notepad++ ? It just loaded a massive MySQL File and it didn't lag, or Crash.


http://notepad-plus.sourceforge.net/uk/site.htm

I had problem opening 2 MB file to convert MySQL from one system to another in Notepad.

Duh, had to use web interface to do that.

P.S: Downloading Scintilla's SCiTE

Wise choice, Haris! You'll adore it, I'm sure.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.