Your extremly simplistic view on this is a result of never dealing in
volumous data and result sets and quick running queries. Once you >put volumes into your thinking cap you will begin to see why you dont just read everything into memory for the hell of it.
Just to complete the above thought. If I wanted everything in memory I would not have any need for sqlite. Standard Data Structures list BST, Hash etc.. will be far more effient for in memory use.
>
