Hi,

I think the "normal" tables could be estimated.

row by size (varchar (32) = 32) will result in a good guess

BUT

the problem will be that there is NO way of evaluating the size og a blob
(long ascii or long byte) in a SQL Statement

like

select sum(datalen(MYBLOB)) from T1

regrads
jph

P.S.

I miss this functionality since the old ADABAS Days .......

___________________________
Dipl.-Ing. Jens-Peter C. Hillers
Remote Web Services GmbH
Tel: +49 40 25 49 06 22
Fax: +49 40 36 00 67 27
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
____________________________


> -----Ursprüngliche Nachricht-----
> Von: Ralf Schneider [mailto:[EMAIL PROTECTED]
> Gesendet am: Dienstag, 20. September 2005 15:17
> An: maxdb@lists.mysql.com
> Betreff: Re: AW: How to track DB usage of user
>
> Am Dienstag, 20. September 2005 14:58 schrieb Robert Klemme:
> > Then probably a limit different from bytes makes more sense?  Maybe
> > something that can be directly translated into record counts (max
> > contacts or similar).
>
> That's right from a developers perspective, but not from a sales
> perspective.
> You can not sell something like "5000 contacts and 50 files or
> 2000 contacts
> and 200 files". What you can sell is a package with 100 MB data
> space. But in
> this case you should count the bytes as exactly as possible.
>
> Best regards,
> Ralf.
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to