Write operations to a SQLite file lock the whole file. It's possible that your rails app had enough users doing enough writes so that the processes had to const

Write operations to a SQLite file lock the whole file. It's possible that your rails app had enough users doing enough writes so that the processes had to constantly wait. As long as you are the only user, performance should be constant regardless of file size (minus fragmentation issues)