Results 1 to 5 of 5
Apr 21, 2009, 08:04 #1
- Join Date
- Oct 2006
- France, deep rural.
- 17 Post(s)
- 1 Thread(s)
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.