Actually, I used the old SAP::DBTech::sapdb interface because of date/time format problems with ODBC. I could try the DBD::ODBC interface and compare the response times.
System is:
RedHat 7.3
Perl 5.6.1
SAPDB 7.3.0.29
everything is on on machine
In my case network speed or shared mem/loopback can't be the issue, because inserts and selects run perfectly reasonable. Just the updates take a long time.
Next week I'll do some tests and let you know the results.
Arne
on Tuesday, 4th of February Arne has posted a question concerning slow updates. We have the same problem and want to add some informations from our side.Maybe, maybe not. Arne didn't tell us which interface he uses.We have installed SAPDB on to operating systems:
- Win2000, data devspace 150 Mb (Testsystem)
- SuSe Linux, data devspace 2000 Mb (productiv system).
The DB-parameters were not changed after installation.
Connection to SAPDB is done by using Perl and ODBC.
The behaviour for the same program under the two different OS is
interesting.
The programs - selects all datasets (~ 5000 rows) from a table, - calculates some field values and - updates the original table ("update ... where primarykey=value")
again.
The duration for this procedure is
- approx. 60 seconds under Win2000
- approx. 420 seconds under Linux
Could this be a problem with ODBC under Linux?
Until now I haven't heard that ODBC runs so much worse under Linux. Some questions: 1. Is in both cases the DB local or remote? 2. If remote, has the network connection the same speed? 3. If local, shared memory is only used, if "ServerNode" is not set, otherwise loopback (definition of DSN). 4. How differ the DB parameters? 5. Does the Linux-box any swapping during the run?
-- Institute of Shipping Economics and Logistics http://www.isl.org/ Arne Gehlhaar mailto:[EMAIL PROTECTED] Universitaetsallee GW1 Block A phone:+49.421.22096.49 D-28359 Bremen, Germany fax:+49.421.22096.55 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
