Hi Hannes
> -----Original Message-----
> From: Hannes Degenhart [mailto:[EMAIL PROTECTED]]
> Sent: Donnerstag, 6. Februar 2003 14:36
> To: sapdb general
> Subject: updates extremely slow
>
>
> 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.
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?
Regards Thomas
----------------------------------------------
Dr. Thomas K�tter
SAP DB, SAP Labs Berlin
SAP DB is open source. Get it! www.sapdb.org
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
