Re: SAPDB vs. Microsoft SQL Server

[Jason Louder]

Hi,

I wonder why nobody replied this interesting topic. I'm sure there are many MSSQL users who want to try SAP DB and need some hints on optimizing the database.

Jason

 [EMAIL PROTECTED] wrote:

Hi to all,

we are testing the performance of two database servers (SAPDB and Microsoft SQL Server).
I know there are several article but none does match our situation.
We have the following environment :

-dual processor PIII win2k server
-1 GB memory
-sapdb 7.3.0 ( 256 mb allocated memory )
-microsoft sql server 7 ( 256 mb allocated )
- win2k client (C++ testapp with mfc-database-support which selects the contents of one table in a loop)
-the fetched table contains about 28000 rows
-the sqlstmt is about : 'select * from <tablename>

out test results :

Connection Time in both cases normal !

SAPDB                              Microsoft SQL Server

  5 sec                                           1 sec
  3 sec                                           1 sec
  3 sec                                   ! !         1 sec
  3 sec                                           1 sec
  2 sec                                           1 sec
  3 sec                                           1 sec
  2 sec                                           1 sec
  3 sec                       &nb! ! sp;                   1 sec
  2 sec                                           1 sec
  3 sec                                           1 sec

My question :

How can I improve the performance for the SAPDB?

Thanks

Tom Zschockelt

---

Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more