Jens-Peter C. Hillers wrote: > > Hi, > > I think the "normal" tables could be estimated. > > row by size (varchar (32) = 32) will result in a good guess >
May be true for 32, but for 2000 ?? > 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 ....... But it is no missing function for MaxDB. Starting with 7.6.00.07 LENGTH (<blob>) is available. And as far as I remember this fact was made public. Elke SAP Labs Berlin > > ___________________________ > 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
