How to prevent outofmemory exeption?

[Red Squirrel]

Not that I know of. This is the code that reads a row:

			Console.WriteLine("Loading Mobiles...");
			
			if(!Core.SQLCON.Query("SELECT * FROM mobiles;"))
			{
				Console.WriteLine("Error loading mobiles!  This is fatal and stuff.  Terminating");
				Console.ReadKey();
				return;
			}
			
			m_Mobiles = new Dictionary<Serial, Mobile>();
			
			
			
			while(Core.SQLCON.FetchRow())
			{
				int serial = Core.SQLCON.Reader.GetInt32(0);
				string serialstr = serial.ToString();
				int typeid = Core.SQLCON.Reader.GetInt32(1);
				string typestr = Core.SQLCON.Reader.GetString(2);
				string serializedata = Core.SQLCON.Reader.GetString(3);

//Do stuff, store serializedata in an array to be used later, then discarded
}

serializedata is the string that gets very large. I checked my DB and the biggest one I got is 80k. I can't see it getting any bigger then 100k per, though, but it is possible. This process is only required at the very start of app startup. Once the string array is processed then the string is broken up into variables (smaller strings, ints, bools, etc).

It's not the best storage engine, idealy I should be structuring everything into a proper SQL structure, but that would require a HUGE rewrite that I'm not ready to do. I rather go this method and just optimize as best as I can.

I was able to store over 1GB of data in a C++ string, and to top it off I was using concatenation with += and it was a non brainer, so I'm sure there must be a way to get C# to allow this too.

And again, ram is not the issue as I have over a gig free during this operation, and even if it was, then it should be using the swap file.