Raspberry DB Performance testing

Helll all,
I want to try different setups (MariaDB on Pi SD-Card; on USB-Drive; Remote DB on Qnap) and see what gives the best results.

Any suggestion on how to (php or console?) do performance measurements?

  • Clicking though NC might be not precise
  • creating some complex nested queries on big tables?

Any better idea?

Some time ago, I started some tests on small file uploads. This creates a huge amount of SQL-queries: https://github.com/owncloud/core/issues/20967

Interesting idea - should work :wink: