Hi,

Is there a way to check how much space table occupies or how much space is left (maybe in percentages)? Some of my clients want to monitor these values.

Marcin.

Marcin,

> Is there a way to check how much space table occupies or how much space is left (maybe in percentages)? Some of my clients want to monitor these values.

Unless there is a function that I don't know: you will have to do that
on your own.

Just count the bytes of each table files(s) and you are done.

Uli

Marcin

>Is there a way to check how much space table occupies or how much space is left (maybe in percentages)? Some of my clients want to monitor these values.

Whatever you give them would be a nonsense figure. Some older, or bigger, databases you specified how big the table was when you created it (or altered it). ElevateDB like DBISAM before it is limited by a maximum number of records and the size of the hard disk. From the pdf manual

<<The maximum number of rows in a table is determined
by the maximum file size permitted in the operating
system, which is affected by whether large file support
is enabled in the application or ElevateDB server. You
can find out more information on how to enable large
file support for ElevateDB in your product-specific
manual.>>

For space used add together the physical file sizes of the three (table columns, index and blob) files. That's how much space the table occupies. Get the physical size of the disk and subtract the previous info from it and that's the space left.

Unfortunately other applications can eat the disk space as well so as I said - meaningless.

Of course you could always not enable large file support then you have a max file size of 2Gb

Roy Lambert [Team Elevate]

Marcin,

<< Is there a way to check how much space table occupies or how much space
is left (maybe in percentages)? Some of my clients want to monitor these
values. >>

Those values aren't really surfaced right now, mainly because they wouldn't
be of much use to most non-developers, and most developers know how to just
look at the file sizes.

As for free space, do you mean the amount of free disk space on the database
drive ?  If so, then they can just use Windows Explorer to examine the drive
space.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks for response from all of you.
I do not want customer to know how large table/file is. I would like to inform that for example 10% free space left (because one of the file used by some table is about to reach DB file limit soon). My application collects events, sometimes there may be a lot of them so even when LargeFileSupport is True some of my customers were not aware that Database cleanup should be performed to free some space.

I was thinking of periodically checking for DB files size and was wondering if such an API already exists, because when I get EDB_ERROR_FULL it is too late. Checking for free space on DB drive is another thing.

Maybe it would be easy to add space used/free to tables table in Information database.

Regards Marcin.

Marcin

Assuming you're using Windows are you seriously saying that you can have files bigger than:

maximum capacities in ElevateDB to:
Operating System Capacity with Large File Support
Windows A maximum file size of 128,000,000,000 bytes for any
physical file (*.EDBTbl, *.EDBIdx, and *.EDBBlb) that is part
of a logical table.

My suggestion:

1. enable large file support
2. If your users want to know free space just quote 50% of the free space left on the drive.


Roy Lambert [Team Elevate]

Marcin,

<< I do not want customer to know how large table/file is. I would like to
inform that for example 10% free space left (because one of the file used by
some table is about to reach DB file limit soon). My application collects
events, sometimes there may be a lot of them so even when LargeFileSupport
is True some of my customers were not aware that Database cleanup should be
performed to free some space. >>

Ahh, so you want to know how much deleted space is present in a table ?
I'll add this to the enhancements list.  It's a good thing to have as part
of a database analysis feature in the EDB Manager also.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>Ahh, so you want to know how much deleted space is present in a table ?
>I'll add this to the enhancements list. It's a good thing to have as part
>of a database analysis feature in the EDB Manager also.

Unless I'm misreading the manual and Marcin's comments "because one of the file used by some table is about to reach DB file limit soon" of
128,000,000,000 bytes - WTF! Seems like a lot of events to me.

Also I know in the early days reuse of deleted space was going to go but I thought that had changed so the deleted record space should be being reused therefore optimising isn't going to achieve much in terms of genuine space geneation.

Or am I being dense here.

Roy Lambert

Roy,

<< Unless I'm misreading the manual and Marcin's comments "because one of
the file used by some table is about to reach DB file limit soon" of
128,000,000,000 bytes - WTF! Seems like a lot of events to me. >>

I just read that as a mistake, perhaps thinking 4GB instead of 128GB.

<< Also I know in the early days reuse of deleted space was going to go but
I thought that had changed so the deleted record space should be being
reused therefore optimising isn't going to achieve much in terms of genuine
space geneation. >>

You are correct (the initial impetus for not reusing was the replication,
but that was resolved).

You can still get a bunch of free space, however, by deleting many rows at a
time.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>I just read that as a mistake, perhaps thinking 4GB instead of 128GB.

That would be without large file support wouldn't it.

>You can still get a bunch of free space, however, by deleting many rows at a
>time.

So reuse isn't 100% or ....

Roy Lambert