How space is used in a database?

I have a database that basically just runs an agent over the web (it squirrels away for data on another system the outputs the html over the web). There are:

Design:

No framesets

1 page (1471 bytes)

2 views (1847 and 1820 bytes each)

0 folders

2 agents (4986 and 16433 bytes)

3 images (900 bytes each)

1 file (1600 bytes)

1 icon (700 bytes)

1 about database doc (1600 bytes)

Documents:

none

I deleted the view using manage views in administrator and the whole thing still 400k after compaction…

Is there any way of knowing how space is used in the database? 400k seems a lot for not a lot of data… This is more for my own education than for any specific issue…

Thanks! :slight_smile:

Adam.

Subject: How space is used in a database?

You forgot to include the Unique Key (UNK) table, the Note index, and all of the other internal structures the NSF uses to manage its own structure. An NSF is not an empty table to which you add data, it starts off with a bunch of defined storage that allows it to later locate the elements you add. A brand-new database created from “Blank” starts off with 256K before you add anything of your own. And everything you add brings in not only its own length, but it also adds data to the various indexes maintained in the database, so the design portion of the database is not going to have zero footprint. But c’mon – 400K wouldn’t be worth complaining about if floppies were still current technology.

Subject: RE: How space is used in a database?

You mean you don’t use the 8" 250k disks like I do? :wink:

cheers for the info

Adam.

Subject: RE: How space is used in a database?

Not since the S-100 bus burned up, no. Took my paper tape collection with it too – I just don’t have the patience to build a PCI card for the old TTY machine…

Subject: How space is used in a database?

Try using Notes Peek to see what else is in there.

Some things that come to mind …

The Item Definition table (holds the names of all fields in the database)

The Replication history

The Unread Marks table(s) (one per user of the database)

The Access Control list

Deletion Stubs

Subject: RE: How space is used in a database?

I’ve been waiting for the service guy to come fix my Babbage Difference Engine for what seems like centuries :frowning: