I think I've isolated the cause of a method failing only in servoy client to memory exhaustion.
The symptoms are that the method runs without complaint but after several minutes stops with an error dialogue: "Error while executing method with name methodName, id 2823". This happens at approximately (but not exactly) the same record (around 5000 out of 6500) each time the method is run.
I presume it's significant that in Help->About the memory is listed as 65088K allocated. If the method is run with the About dialogue open, used memory is seen to rise to at least 58800K (it later drops to ~24000K used).
Am I bumping into a 64MB VM limitation?
FWIW, the method executes a search which returns ~6000 records then runs a loop through this foundset to sum a field. Curiously, this works just fine (and gets the correct result) if run in Developer (although memory usage does get uncomfortably high).
This is with Servoy 2.0.4-build 277. Server is running java 1.4.2. Verified same behaviour with client running on Linux (Java 1.4.2_03-b02(Linux)) and Mac (Java 1.4.1_02-24(Mac OS X)).
Any ideas?
Thanks,
Neale.