Dear all,
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.
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?
Thanks for your comments 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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
