Toad World® Forums

out of memoey when running query


#1

Hi

When i try ro export some data from a table i receive the following error:

‘system.OutOfMemoryException’ was thrown. If I try to run this in Access in works fine.

The server is windows 2003 enterprise with 8Gb of RAM.

Is this an issue with Toad or does it physically run out of RAM? Why would this work in Access?

Any help much appreciated.

Thanks


#2

Each export type handled memory differently. Try exporting as Comma Separated values. I believe this is the most efficient.

Debbie


#3

hi debbie,

Thanks for the respone but i still receive an error when i use a csv file. It only does 1 million out of 2.2 million recoreds

I have also checked the performance of the server and the memory only rises to 25% before the crash.

I receive the following error
Thanks

System.InvalidOperationException
Failed to compare two elements in the array.
Stack Trace:
at System.Array.SorterObjectArray.QuickSort(Int32 left, Int32 right)
at System.Array.Sort(Array keys, Array items, Int32 index, Int32 length, IComparer comparer)
at System.Collections.ArrayList.Sort(Int32 index, Int32 count, IComparer comparer)
at System.Collections.ArrayList.Sort(IComparer comparer)
at DevExpress.XtraBars.MessageFilter.BarManagerMessageFilter.System.Windows.Forms.IMessageFilter.PreFilterMessage(Message& m)

System.OutOfMemoryException
Exception of type 'System.OutOfMemoryException' was thrown.
Stack Trace:
   at DevExpress.XtraBars.MessageFilter.BarManagerMessageFilter.ManagersComparer.System.Collections.IComparer.Compare(Object a, Object b)
   at System.Array.SorterObjectArray.QuickSort(Int32 left, Int32 right)

Message was edited by: phillbat