Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 18 of 18 total |
In memory database |
Fri, Mar 30 2007 10:47 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Mar 30 2007 10:48 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Fri, Mar 30 2007 11:50 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Mar 30 2007 11:50 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Mar 30 2007 11:50 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Mar 30 2007 12:00 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Sorry for the hiccoughs Roy Lambert |
Tue, Apr 3 2007 9:04 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Apr 3 2007 9:30 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
That was going to be the next question I'll just build a DROP Table into my function. Roy Lambert |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |