Memory and crashing

[Ivan Smahin]

Hello Steve,

Tuesday, July 3, 2007, 7:02:23 AM, you wrote:

SA> I have one Windows user that is constantly getting a hard Windows
SA> crash when executing a certain SQL statement in my app.  I feel
SA> certain it is the SQL because I have the Valentina log turned on
SA> and it ends without returning from the call.  My other Mac and
SA> Windows users are not having a problem with this same code.  

SA> I obtained an exact copy of the database and I was only able to
SA> recreate the crash in Windows if I started lots of other
SA> applications before firing up Parallels on my Mac to run Windows. 
SA> My theory is that the app is running out of memory while trying to
SA> execute a complicated SQL statement.

SA> My question is this:  Is it expected for an app to have a hard
SA> crash if it can't get enough memory?  Is this something that
SA> bypasses the normal exception processing?

SA> This user has the largest database by far of all my users and
SA> only has 1GB of memory for Windows XP.  Does 1GB of memory seem
SA> like enough for a Valentina app?  My knowledge of Windows is
SA> rudimentary so I really don't have a handle on this.

SA> I'm programming in REALbasic 2007r3 if that makes a difference.


So, it is the same database structure for all users - right?
And that user has biggest database.
Generally  we  are  expecting  out  of  memory situation but
obviously not always.

Can you send me the project and empty database and tell me the way I can easy
fill it with data to test it here?

On the other hand the only thing we can do - throw some exception
instead of crashing. I don't think it will be suitable for that user.

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com