Re: Perl DBD::ODBC / low CATALOG CACHE hit rate

[Hannes Degenhart]

Dear Thomas, Arne,

thanks for your replies.

Thomas, yes I think it's related to this object.
I have no idea what the exact differences of DBD::ODBC between 0.38 and 
1.01 are!

Arne, it is interesting that you didn't have this effect
( CATALOG CACHE !!!) on your system.
So I think I'll first try SAP-DB 7.4 on my test machine to see what 
happens. If there should be no success I think about downgrading 
DBD::ODBC to < 0.42.

Thanks and
best regards
   Hannes Degenhart

--

Hannes Degenhart GPS - Gesellschaft zur Pruefung von Software mbH
                 Hoervelsinger Weg 54        D - 89081 Ulm - Germany
                 Pho. +49 731 96657 14       Fax. +49 731 96657 57
                 mailto:[EMAIL PROTECTED] Web: http://www.gps-ulm.de
Koetter, Thomas Theodor wrote:
Dear all,

we are using SAP-DB (7.3.0.30) with Perl DBD::ODBC 1.01

As written from Jeroen Boomgaardt in February 2003 we also recognize 
that the CATALOG CACHE hit rate doesn't exceed approx 70%.
Could it be that this is related to http://sapdb.2scale.net/moin.cgi/PerlDbiDbdOdbc
>
Regards  Thomas
Arne Gehlhaar wrote:

> I've posted this before, but since you ask:
>
> We are currently using:
> SAP-DB 7.4.3.10
> DBI 1.32
> DBD-ODBC 1.01
> unixODBC 2.2.3
> on RedHat Linux and our cache hitrate is constantly at 99%.
> (CACHE-SIZE=20000).
>
> Regards,
> Arne Gehlhaar




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