topic Benchmark oracle vs maxdb in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/benchmark-oracle-vs-maxdb/m-p/3045149#M720814 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>we will change our db from oracle to maxdb (our basis does it) and i shell</P><P>test the performance of the maxdb to optimize the parameter</P><P>of maxdb.</P><P></P><P>Now i will do something in SD, MM, PP, FI etc. and comare it between our old</P><P>and new system.</P><P></P><P>Question: Are there any standart benchmarks to test performance?</P><P>Is there any documentation what kind of tests will shell do (f. example ME21N, FB01, F110, F150, CO01 etc.)? Any documentation in german?</P><P></P><P>Thanks for help.</P><P></P><P>Regards, Dieter</P></BODY></HTML> Thu, 15 Nov 2007 13:22:58 GMT Former Member 2007-11-15T13:22:58Z Benchmark oracle vs maxdb https://community.sap.com/t5/application-development-and-automation-discussions/benchmark-oracle-vs-maxdb/m-p/3045149#M720814 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>we will change our db from oracle to maxdb (our basis does it) and i shell</P><P>test the performance of the maxdb to optimize the parameter</P><P>of maxdb.</P><P></P><P>Now i will do something in SD, MM, PP, FI etc. and comare it between our old</P><P>and new system.</P><P></P><P>Question: Are there any standart benchmarks to test performance?</P><P>Is there any documentation what kind of tests will shell do (f. example ME21N, FB01, F110, F150, CO01 etc.)? Any documentation in german?</P><P></P><P>Thanks for help.</P><P></P><P>Regards, Dieter</P></BODY></HTML> Thu, 15 Nov 2007 13:22:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/benchmark-oracle-vs-maxdb/m-p/3045149#M720814 Former Member 2007-11-15T13:22:58Z Re: Benchmark oracle vs maxdb https://community.sap.com/t5/application-development-and-automation-discussions/benchmark-oracle-vs-maxdb/m-p/3045150#M720815 <HTML><HEAD></HEAD><BODY><P>I would use the explain function of ST05 to compare the two. But bear in mind that explain may not be available in MaxDB. (And the results may not be comparable.)</P><P></P><P>But it could be a start.</P><P></P><P>Rob</P></BODY></HTML> Thu, 15 Nov 2007 15:09:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/benchmark-oracle-vs-maxdb/m-p/3045150#M720815 Former Member 2007-11-15T15:09:51Z