--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> At 11:41 PM 4/03/2004 +0000, you wrote:
>
> >Anyway
> >Are we talking about the same thing ?
>
> No, apologies, gotta get some sleep. :(
>
> So, back to the drawing-board...
>
>
> >Its not FB that uses this amount of RAM.
> >Its my own appl. !
> >And this has started since I changed some comp. from TIBOQuery to
> >either TIB_DSQL or TIBCursor.
> >
> >It seems as if my OWN appl. just uses more and more RAM.
> >At one point in my program, I have tried to COMMIT all

transactions,

> >closing all querys and cursor, and closing the connection to the DB
> >and reconnect.
> >It still uses this amount of RAM.
>
> Can you show the SQL for a couple of these dsql and cursor objects,

and the

> code that you use with them?

I could, but before I do, I would like to ask another thing.

What happens if I open a cursor, and do not close it before a commit ?
Will this affect this ?

I have for fun, just taking an older version of my appl. which
doesn't use cursors or dsql.
Works perfect.

Differences between to two version is 1 newly added menu (which in my
test are not executed) and the TIBOQuery converted to TIB_Cursor and
TIB_DSQL.


Regards
Michael

>
> Helen