Subject Re: application using up ram
Author Michael Vilhelmsen
--- In, 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
> >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

> Helen