Subject | Database garbage collection |
---|---|
Author | Rik Barker |
Post date | 2006-06-07T08:47Z |
Hi,
It's just occurred to me that when using embedded server, if our app isn't
running, the database is unlikely to ever perform a pack (by which I mean
remove any deleted records - is that called sweep now?)
The app I'm working on might well do 100,000 deletes and 100,000 inserts
every couple of days - I want to ensure I keep the database well
tidied. Is there a way to instigate database administration tasks through
API calls? Is it even necessary?
Cheers,
Rik
It's just occurred to me that when using embedded server, if our app isn't
running, the database is unlikely to ever perform a pack (by which I mean
remove any deleted records - is that called sweep now?)
The app I'm working on might well do 100,000 deletes and 100,000 inserts
every couple of days - I want to ensure I keep the database well
tidied. Is there a way to instigate database administration tasks through
API calls? Is it even necessary?
Cheers,
Rik