SAPDB vs. Microsoft SQL Server

[Tom . Zschockelt]

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                                           1 sec
  2 sec                                           1 sec
  3 sec                                           1 sec

My question :

How can I improve the performance for the SAPDB?

Thanks

Tom Zschockelt