Can I ask what is the point of having tests that take that long to run? Being notified 3 weeks after I made a change that I broke something is pretty useless to me...

And what language/framework or other reason could possibly contribute to that long a test suite?

Release acceptance test for database engine. Terabytes of data, stress tests. I have smaller sets which runs in 10 minutes and overnight.

I do not work on SQLite, but here is something similar: http://www.sqlite.org/testing.html