> -----Ursprüngliche Nachricht----- > Von: Zabach, Elke [mailto:[EMAIL PROTECTED] > Gesendet am: Dienstag, 20. September 2005 16:09 > An: [EMAIL PROTECTED]; Ralf Schneider; maxdb@lists.mysql.com > Betreff: AW: How to track DB usage of user > > 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 ?? so take the middle ! were talking about 64K. I'll think some Megabytes are your Problem ! or use select count(*)*avg(length(YourVarcharField)) from t1
> > > > 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. This works ! never estimated this to come sometime ! Thanks jph > > 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] ___________________________ 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]> ____________________________ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
