Percentange of Database Population (complete)? 1

[TCARPENTER]

Hi all,

I have a strange request to fulfill, the boss wants to know what percentage of the database has been populated. My first thought was to count the total number of fields, and compare the non-null fields to the total fields and just use this, but I'm wondering if anyone else has had to do this and how you went about determining the percent complete of the database?

Any and all suggestions would be appreciated?

Thanks
Todd

 

[lupins46]

For what purpose?
Do you expect all fields to have entries over a given period of time?

 

[TCARPENTER]

Hi lupins46,

Good question. The boss has to justify his existence to the powers that be, so in addition to everything else he has to do, he's looking for some way to tell the progress with the database population.

And no, we don't expect all fields to have entries over a given period of time, but we do expect certain fields to be populated by a certain time.

Todd

 

[lupins46]

Then your suggested method is as good as any.
I think you need to decide what constitutes 100% though.
(Otherwise, you will get permanently stuck at say 88%, because there is no more valid data to be entered.)

 

[TCARPENTER]

Hi lupins46,

Thanks for the input, that's kind of what I leaning towards, it's good to get a second confirming opinion!

Todd