#3361 Out of memory - large files

[Anonymous]

Originally created by: jeffgem... (code.google.com)@gmail.com

What exact steps will reproduce the problem?
1.  Open large file (over 100MB)
2.  Out of memory

What was the expected output?
Open the file in the editor

What happened instead?
Out of memory

Suggested fix (optional)?
Consider increasing the file size that the editor can load.  I have some files that are up to 500MB and it would be nice to load them if possible.   

Version used? 8.1
MySQL Server version: 5.6.1.3.1
Operating system: Windows 7

[Anonymous]

Originally posted by: a...@anse.de

HeidiSQL already has an alternative - parsing/running such files directly. Why didn't you select that - you were warned?

The SynEdit guys can probably help more, but I'm sure they say the same.

Status: CantFix

[Anonymous]

Originally posted by: jeffgem... (code.google.com)@gmail.com

I didn't want to run the sql, just view and possibly edit it and since my SQL files are associated with the app, it would make it easier.  Seems odd that problem can't be fixed.  Even with 32bit and a possible 1Gig memory limit along with the expansion of bytes to string primitives, it should be able to pull the entire file into memory as a string or byte array.  I guess the primary issue is possible limits on the editor itself displaying that much text, syntax highlighting, etc.  Maybe some level of pagination in such cases (you wouldn't even need to pull the entire file into memory).  Anyway.. I can open it in something else and maybe that's the easiest thing, but other editors can open files that large.  Notepad++, Jujuedit, TextPad can open 2GB files, so they must be doing something different (others can load more but then we're getting into 64bit).

I do like the tool - very nice - better than MySQL Workbench.  :) 

Couple other suggestions while I'm typing.  The icon for the file type could better represent a file, as oppose to using the same icon as the app.  I have about 10 Heidi icons on my desktop and they all look the same. haha

Another thing is that you can Export to Grid if you select all on a query and right click.  You should make this an option from on of the main menu drop downs or an icon as it's not an obvious feature but it's really handy.

[Anonymous]

Originally posted by: a...@anse.de

Grid export: See Tools > "Grid export"

And yes, syntax highlighting may be the cause of these memory usages. PSpad also uses this SynEdit component, and it has the same limitations.