1

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?

Community
  • 1
  • 1
xun
  • 607
  • 2
  • 7
  • 10
  • Before going this route, note that an often accessed file will be cached in memory by the OS by default, so if the number of writes are not that high, there is probably not a real big gain in performance. – Wrikken Feb 01 '12 at 23:13
  • I don't believe temporary tables would help either: as far as I'm aware, SQLite holds those in memory where it can, but the PHP SQLite doesn't allow you to create them – Mark Baker Feb 01 '12 at 23:21

0 Answers0