Hi Hannes > -----Original Message----- > From: Hannes Degenhart [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 21. Oktober 2003 09:44 > To: Maxdb > Subject: Perl DBD::ODBC / low CATALOG CACHE hit rate > > > 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 excert: DBD-ODBC version: if your application uses cached connections (connect_cached) then use version 0.41. It is recommended to use a version < 0.42, as in 0.42 the ping() method was implemented differently, which significantly reduced SAP-DB's catalog cache hit rate. The ping method was changed due to problems with Openlink. The old method (still in the module, oldping) sends a simple select to the db and evaluates the intended error message. The new ping calls SQLTables, which results in a quite expensive SQL statement disturbing caches etc. Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
