SQLite Forum

select in order
Login
Chronological Hierarchical 
Try writing into tmpfs. That's a bit faster than SSD.