Working with large files

Toad for SQL Server
1

I don’t know if it was good in previous versions, but this version, having
to deal with large files in the query window gives you:
System.OutOfMemoryException
Exception of type ‘System.OutOfMemoryException’ was thrown.
Stack Trace:
at a5.a(Int32 A_0)
at a5.a(Int32 A_0, Byte[] A_1)
at g.a(DocumentModificationEventArgs A_0)
at ActiproSoftware.SyntaxEditor.SyntaxEditor.d(Object A_0,
DocumentModificationEventArgs A_1)
at ActiproSoftware.SyntaxEditor.Document.b(DocumentModificationEventArgs
A_0)
at ActiproSoftware.SyntaxEditor.Document.a(DocumentModification A_0,
Boolean A_1)
at ActiproSoftware.SyntaxEditor.Document.b(DocumentModificationType A_0,
Int32 A_1, Int32 A_2, String A_3, DocumentModificationOptions A_4, WeakReference
A_5)
at ActiproSoftware.SyntaxEditor.Document.a(DocumentModificationType A_0,
Int32 A_1, Int32 A_2, String A_3, DocumentModificationOptions A_4, WeakReference
A_5)
at ActiproSoftware.SyntaxEditor.EditorView.a(DocumentModificationType A_0,
String A_1, DocumentModificationOptions A_2)

at

ActiproSoftware.SyntaxEditor.EditorView.ReplaceSelectedText(DocumentModificationType
type, String text, DocumentModificationOptions options)

at

ActiproSoftware.SyntaxEditor.Commands.PasteFromClipboardCommand.Execute(EditCommandContext
context)
at ActiproSoftware.SyntaxEditor.MacroRecording.a(EditCommand A_0,
EditCommandContext A_1)
at ActiproSoftware.SyntaxEditor.EditorView.a(EditCommand A_0, Boolean A_1)
at ActiproSoftware.SyntaxEditor.EditorView.RaiseEditCommand(EditCommand
command)
at ActiproSoftware.SyntaxEditor.EditorView.PasteFromClipboard()
at Quest.Toad.Editor.EditorControl.DoPaste()
at Quest.Toad.Editor.EditorForm.DoPaste()
at Quest.Toad.Gui.MainForm.pasteButton_ItemClick(Object sender,
ItemClickEventArgs e)
at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link)
at DevExpress.XtraBars.BarBaseButtonItem.OnClick(BarItemLink link)
at
DevExpress.XtraBars.ViewInfo.BarSelectionInfo.OnShortcutItemClick(BarItem item,
BarShortcut shortcut)
at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.CheckShortcut(BarManager
manager, KeyEventArgs e)
at
DevExpress.XtraBars.MessageFilter.BarManagerHook.PreFilterMessage(Message& m)

at

DevExpress.XtraBars.MessageFilter.BarManagerMessageFilter.System.Windows.Forms.IMessageFilter.PreFilterMessage(Message&
m)

This is for a 300000 lines file.

dani

2

Hi Dani,

Can you please let me know what is the size of the file?
Also, can you please let me know your case? are you going to edit such a long script?

3

Hi Valentine,
This is a 300K rows file. It “auto generated” by a query, the results which is
SQL commands exported to Excel, and then I try to cut and paste it back to TOAD.

I can cut it to smaller chunks. the “bug” in toad is that once I try it twice

  • the programs hangs and stop responding.
    It is a memroy issue (the actual code is not relevant as toad has no chance to
    evaluate it or run it)

Dani

2011/9/29 Valentin Baev

Message from: Valentine

Hi Dani, Can you please let me know what is the size of the file? Also, can
you please let me know your case? are you going to edit such a long script?

_______________________________________

Historical Messages

Author: Valentin Baev
Date: Thu Sep 29 06:26:48 PDT 2011
Hi Dani, Can you please let me know what is the size of the file? Also, can
you please let me know your case? are you going to edit such a long script?
__

Author: kaplan.dani_609
Date: Thu Sep 29 01:31:09 PDT 2011

I don’t know if it was good in previous versions, but this version,
having to deal with large files in the query window gives you:
System.OutOfMemoryException Exception of type
‘System.OutOfMemoryException’ was thrown. Stack Trace: at
a5.a(Int32 A_0) at a5.a(Int32 A_0, Byte[] A_1) at
g.a(DocumentModificationEventArgs A_0) at
ActiproSoftware.SyntaxEditor.SyntaxEditor.d(Object A_0,
DocumentModificationEventArgs A_1) at
ActiproSoftware.SyntaxEditor.Document.b(DocumentModificationEventArgs A_0)
at ActiproSoftware.SyntaxEditor.Document.a(DocumentModification A_0,
Boolean A_1) at
ActiproSoftware.SyntaxEditor.Document.b(DocumentModificationType A_0, Int32
A_1, Int32 A_2, String A_3, DocumentModificationOptions A_4, WeakReference
A_5) at
ActiproSoftware.SyntaxEditor.Document.a(DocumentModificationType A_0, Int32
A_1, Int32 A_2, String A_3, DocumentModificationOptions A_4, WeakReference
A_5) at
ActiproSoftware.SyntaxEditor.EditorView.a(DocumentModificationType A_0,
String A_1, DocumentModificationOptions A_2) at

ActiproSoftware.SyntaxEditor.EditorView.ReplaceSelectedText(DocumentModificationType
type, String text, DocumentModificationOptions options) at

ActiproSoftware.SyntaxEditor.Commands.PasteFromClipboardCommand.Execute(EditCommandContext
context) at ActiproSoftware.SyntaxEditor.MacroRecording.a(EditCommand
A_0, EditCommandContext A_1) at
ActiproSoftware.SyntaxEditor.EditorView.a(EditCommand A_0, Boolean A_1)
at ActiproSoftware.SyntaxEditor.EditorView.RaiseEditCommand(EditCommand
command) at
ActiproSoftware.SyntaxEditor.EditorView.PasteFromClipboard() at
Quest.Toad.Editor.EditorControl.DoPaste() at
Quest.Toad.Editor.EditorForm.DoPaste() at
Quest.Toad.Gui.MainForm.pasteButton_ItemClick(Object sender,
ItemClickEventArgs e) at
DevExpress.XtraBars.BarItem.OnClick(BarItemLink link) at
DevExpress.XtraBars.BarBaseButtonItem.OnClick(BarItemLink link) at
DevExpress.XtraBars.ViewInfo.BarSelectionInfo.OnShortcutItemClick(BarItem
item, BarShortcut shortcut) at
DevExpress.XtraBars.ViewInfo.BarSelectionInfo.CheckShortcut(BarManager
manager, KeyEventArgs e) at
DevExpress.XtraBars.MessageFilter.BarManagerHook.PreFilterMessage(Message m)
at

DevExpress.XtraBars.MessageFilter.BarManagerMessageFilter.System.Windows.Forms.IMessageFilter.PreFilterMessage(Message
m) This is for a 300000 lines file. dani

__
_______________________________________
4

Dani, can I participate in this issue… If so please forward me the details, I
may have had the same experience and have a work-a-round.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image002.jpeg

5

Dani, can I participate in this issue… If so please forward me the details, I
may have had the same experience and have a work-a-round.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image001.gif

6

Hi hank
The work around is to write better sql queries. I didn't write this one and
i'll fix it. I do like to help improve the toad software and there are ways
to deal with,large memory consuming text in the editor (swap file for example)

If i.won't be able to create a procedure to run this code i'll post it
here.
Thanks anyway
Dani

On Sep 29, 2011 5:56 PM, "Hank_Freeman(msn)" wrote:

Dani, can I participate in this issue.. If so please forward me the details,
I may have had the same experience and have a work-a-round.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)

Description:
cid:_1_0F90A2AC0F909EBC00581EB48525754C

Description: HANK_001.bmp

7

I will be glad to assist with the excel to Toad-SS part of the adventure, just
let me know.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image002.jpeg

8

I will be glad to assist with the excel to Toad-SS part of the adventure, just
let me know.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image001.gif