After reading PHP / SQLite - Copying a table from disk to memory I must ask this question.
Let's say I have a web page that uses some data upon every page load, I want it to be in shared memory since the data could get large, APC could solve that. I need to be able to search the data and use aggregate functions etc.. so sql is the way to go.
The ultimate solution would be sqlite's :memory: table, but in PHP, such tables won't be persistent.
Does it possible to store sqlite's :memory: tables in APC? Or any other solution to that problem?