Improve testing speed

[driesvints]

For some reason, our test suite is super slow. We should look into this and try to decrease memory usage and speed it up.

Parallel run:

  Tests:    316 passed (785 assertions)
  Duration: 13.64s
  Parallel: 10 processes

Regular run:

  Tests:    316 passed (785 assertions)
  Duration: 96.30s

[driesvints]

We got it to run much faster now with #1151 but we might want to investigate individual slow tests going forward with vendor/bin/pest --profile

For example, the password reset test takes 3 seconds? 🤔

[Nathan-Cowin]

Apologies not sure best way to link my PR: #1167 - Improves by 1/3, cheers

[driesvints]

Thanks @Nathan-Cowin. Also a good improvement. Will leave this open to see if we can get it down even further eventually.

[Nathan-Cowin]

Another easy second here #1169

[AbdulrahmanReda70]

Hi @driesvints

Just a suggestion I wanted to share: I tested running MySQL in memory using tmpfs during testing, and it made the test suite more than 2× faster.

It's completely optional, works only on Linux, and doesn't affect development or CI. Thought it might be helpful to share in case anyone’s interested in speeding up local test runs

[AbdulrahmanReda70]

Hi @driesvints,

I've discovered a significant performance improvement for the test suite that reduces execution time by approximately 70%.
The Change: Replacing DatabaseMigrations with RefreshDatabase in test files.
#1332