Roy,

<< The data is probably disappearing from ram (I have no real no way of
knowing) but the definition stays in the configuration database so when I
reopen an app the memory database is already defined. >>

Yep, that is exactly correct.

<< I'm used to disk databases/tables staying put but not memory ones. Those
I would expect to be transient. >>

Only the database definition stays - the database catalog information goes
away with the database data when the application closes.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< What happens to the table definition in the memory database when the app
closes? >>

It's gone.

<< Will "DELETE FROM memorytable" reclaim the space? If not we need
something that allows us to do so. >>

There's no need to reclaim the space - closing the application does so since
the space is allocated in the virtual address space for the application,
just like any other memory allocation.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< Will "DELETE FROM memorytable" reclaim the space? If not we need
>something that allows us to do so. >>
>
>There's no need to reclaim the space - closing the application does so since
>the space is allocated in the virtual address space for the application,
>just like any other memory allocation.

Sorry should have added "while the application is running" otherwise virtual memory can get filled up (and yes I know we get a lot these days but I still remember IBM saying 16Kb of RAM is enough)

Roy Lambert

Tim

><< Will "DELETE FROM memorytable" reclaim the space? If not we need
>something that allows us to do so. >>
>
>There's no need to reclaim the space - closing the application does so since
>the space is allocated in the virtual address space for the application,
>just like any other memory allocation.

Sorry should have added "while the application is running" otherwise virtual memory can get filled up (and yes I know we get a lot these days but I still remember IBM saying 16Kb of RAM (or some such small number) is enough)

Roy Lambert

Tim

><< Will "DELETE FROM memorytable" reclaim the space? If not we need
>something that allows us to do so. >>
>
>There's no need to reclaim the space - closing the application does so since
>the space is allocated in the virtual address space for the application,
>just like any other memory allocation.

Sorry should have added "while the application is running" otherwise virtual memory can get filled up (and yes I know we get a lot these days but I still remember IBM saying 16Kb of RAM (or some such small number) is enough)

Roy Lambert

Tim


Sorry for the hiccoughs

Roy Lambert

Roy,

<< Sorry should have added "while the application is running" otherwise
virtual memory can get filled up (and yes I know we get a lot these days but
I still remember IBM saying 16Kb of RAM (or some such small number) is
enough) >>

The only way to reclaim the space is to drop the table(s) or database(s).

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


That was going to be the next question I'll just build a DROP Table into my function.


Roy Lambert