Pointers on best use of sqlite 'in memory' databases?
Can anyone share the cases of when they have used sqlite :memory: databases?
I was able to use APC in the past which was fantastically fast, but I have never thought of using sqlite::memory: before.
I realise that if the server loses power then everything is lost, but I have a few thousand records I'd like to use - a bit like a readonly 'in memory array' so data loss is not an issue for me.
Once loaded in memory is this database then really available to all connections?
How do I make sure the database is loaded in memory whenever the service is restarted?
Any experience good or bad would be welcomed.