>>How come my program goes from 45MB to 150 MB of memory when 1 new form is open.
>>
>>Is it that SQL query are too complicat4ed or too many scan...
>>
>>The system gets slow and we are not efficient.
>>
>>Any idea.
>
>Do some debugging - like WAIT in strategic positions, and see exactly at what moment memory consumption goes down. For instance, if you suspect the SELECT statement, do a WAIT right before and after the SELECT statement, and use your memory tools at that point to do the checking.
You may also run CoverageProfiler (set coverage to MyFile.log) and then analyze the result using CoverageProfiler by Martin Jindra from Downloads section here.
If it's not broken, fix it until it is.
My Blog