Perhaps you're like me and saw your massive table slow down alot....
Here is a simple problem:
"SELECT * FROM episodes LIMIT {limit} OFFSET {start*limit};"
The problem is quite insidious because it runs in 0.05s when you start, but by the 30 millionth row it might take 10s.... This is because the offset rule in sqllite will actually go through the database throwing out rows, until you get to the offset desired!!