My reason is mostly to increase performance since this is a relatively small database and will be accessed constantly. Its size is also not likely to increase much.
You don't define what "small" is. You should first make sure you even have a problem. SQLite does in memory buffering anyway with a default of around 2MB. If your database is smaller than that then you'll get everything out of memory anyway. You can use various pragmas to change how much buffering is done. http://sqlite.org/pragma.html#modify (The OS also does buffering so you are actually unlikely to be limited by disk performance for a small database). Roger
