>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)