> > Hi > We were using SapDB 7.3.0.23 / DBI ???? and DBD-ODBC 0.38 > Last week we wanted to update our dbase software. First we > updated sapdb to 7.3.29, and DBI to 1.32. > > When we tried to update DBD-ODBC we ran into problems: > Versions > 0.43 gave errors with make test, data truncated, > so we decided for the moment to use 0.43. After installing > 0.43, we saw the load on our database systems double.
Versions AFTER 0.43 switch to DBD::ODBC being an ODBC v3 client rather than a v2 client. That may be a difference between the two. I haven't tested (although it was on my list a while back) to get sapdb. I just ran out of steam. The ping method should be the same with 0.43 and newer versions. > After exploring we found this was because of the way DBD-ODBC > checks if a connection is still alive. Because of this, our > catalogue cache hit rate dropped from >95% to a mere 60% Is this because you are using the ping() method? The ping method changed across versions due to compatibility issues with various databases and "results". I would guess that the current version, since it uses SQLTables, may be slow based upon the number of tables you have. That can probably be trimmed down to me picking a non-used Schema which should return no tables, but I didn't have time to really test across all platforms. Patches welcome, if you can improve your situation, I'll try it with the databases I use here. If you can't, I'd suggest going to the archives for 0.28 and replacing the ping method from there... Jeff > > Has anyone else experienced the same problem and how do we solve this? > > Greetz > Hans > > On Sat, 2003-01-25 at 18:05, Jeff Urlwin wrote: > > Mainly fixing portability problems with 1.03. Should now build and > > run on all supported platforms... > > > > The uploaded file > > > > DBD-ODBC-1.04.tar.gz > > > > has entered CPAN as > > > > file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-1.04.tar.gz > > size: 88000 bytes > > md5: a1495eea2e902c32040b57c10bcec761 > > > > No action is required on your part > > Request entered by: JURL (Jeff Urlwin) > > Request entered on: Sat, 25 Jan 2003 16:52:03 GMT > > Request completed: Sat, 25 Jan 2003 16:52:39 GMT > > > > Virtually Yours, > > paused, v89 > > > -- > Hans Scheffers > http://www.jiffie.nl/stamboom/ > > The bank called to tell me that I'm overdrawn, Some freaks > are burning crosses out on my front lawn, And I > *can't*believe* it, all the Cheetos are gone, > > Linux Kernel 2.4.18-19 on a i686 - userid 282784 @ http://counter.li.org
