Yes. This has been done before. See GEPS 16: Enhancing Gramps Processing Speed for details. The Debugging Gramps page in our wiki has a section on profiling.
You can see some historic test results on our Gramps Performance wiki page.
We also have a Tips for large databases page which need updating for the SQLite backend. I’ll add a section for increasing the cache size.