PHP: optimum configuration storage?

My application gets configured via a lot of key/values (let's开发者_Go百科 say 30.000 for instance)

I want to find the best deployment method for these configurations, knowing that I want to avoid DEFINEs to allow for runtime re-configuration.

I have thought of

• pre-compiling them into an array via a php file
• pre-compiling them into a tmpfs sqlite database
• pre-compiling them into a memcached db

what are my options for

• the best random access time to these configuration (memory is not an issue) ?
• the best structured access time if i can break up these configuration into families like (network, i18n, ..)

Thanks Jerome

Well, if memory isn't an issue, just serialize an array to a file. There is absolutely no faster solution than this. You don't have the I/O and library overhead of SQLite, and you don't have the network overhead of memcached.

But keep in mind, memory must really not be an issue. You'd be loading the entire 30,000 element array into memory at once, as opposed to using a database, where you could load them on an as-needed basis.

To structure the settings, you could put each in its own file.

But really, you should be using a database. That's what they're there for. I really question why you would need to worry about 30k settings..you might want to reconsider your application design.

How about in a database?

With a schema like this:

| key | value |

You could have data like this:

| currency | pound |
| timezone | GMT   |

It also means you can query it like this:

SELECT * FROM options WHERE key = 'timezone'

Or even return many options:

SELECT * FROM options WHERE key IN ('timezone','currency')

This can be in any kind of database, not least an SQLite database. If you're using a language such as PHP you can use ADOdb for database abstraction so your application is portable between different database types, just a thought if you were concerned about being tied down to one database.

If you want structured, I'd say ini files using the parse_ini_file function.