Another aspect of IBO is it keeps a session level buffer that once it
expands it will remain expanded until the session is released. In most cases
this won't be until the application is ended.

Do it twice and see if it does it again. it should stay the same.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Kevin D. Joseph" <kjoseph@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, July 27, 2001 7:55 AM
Subject: Re: [IBO] tib_cursor memory usage/allocation


> Thanks Jason. here is what I'm doing:
>
> with qry1 do
> begin
> close;
> if (not prepared) then
> begin
> prepare;
> end
> open;
> first;
> while (not EOF) do
> begin
> // do some work
> next;
> end
> close;
> unprepare;
>
> Is this correct? It does not seem to be releasing the memory.
>
> TIA,
>
> Kevin Joseph
> kjoseph@...
>
>
> On Thu, 26 Jul 2001, Jason Wharton wrote:
>
> > You need to do an Unprepare in order to make it release all of its
dynamic
> > resources.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: "Kevin D. Joseph" <kjoseph@...>
> > To: <ibobjects@yahoogroups.com>
> > Sent: Thursday, July 26, 2001 3:04 PM
> > Subject: [IBO] tib_cursor memory usage/allocation
> >
> >
> > >
> > > Hi all,
> > >
> > > I am trying to get some information about how memory is
> > > used/allocated by the tib_cursor. When I prepare the cursor I see
memory
> > > usage increase between 4 and 20 K depending of the cursor. When I
close
> > > the cursor no memory is released. Is this the way it should be? If
so,
> > > short of building and freeing the cursors on the fly is there a way to
> > > free the memory?
> > >
> > > TIA,
> > >
> > > Kevin Joseph
> > > kjoseph@...
> > >
> > >
> > >
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> > >
> > >
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>