On: Wp-SQLite: WordPress running on an SQLite database

[r2_pilot]

That is terrifying that you know this. I am almost curious but would rather not know more.

[technion → r2_pilot]

It'll become unusable at a few hundred meg when it takes 180 SQL queries to render a landing page.. I wish I didn't know that either.

[2000UltraDeluxe → technion]

A few hundred megs for a single page? Yes.

For an affiliate site with millions of pages you need much more to make WordPress sluggish. On the other hand, it only takes a single badly written plugin to achieve the same effect. :D