PHP + MySql VS. HANA

[former_member197620]

HI, experts,

     I write a same function with "PHP + MySql" and "HANA XS". Now I use "ab" tool (V2.3) to perform a performance test. The command is:

"ab -n 1000 -c 100 "http://XXX.XXXXXX":

  (PHP + MySql)

  (HANA)

  “PHP+MySql" performance is better than "HANA".  Why?

  Thanks and Best regards,

  Candy, Zhang

[former_member197620]

When I perform the test, I  go to HANA Administration -> Overview:

The CPU Usage is the highest.

[lbreddemann]

Without any knowledge of what exactly you're doing there is only a slim chance to find the reason for the performance difference.

But looking at the massive difference of the transfer rate my wild blind shot into the absolute dark would be: your network connection to the SAP HANA server is orders of magnitude worse than the one to the other system.