Large lookup table

[Behemoth]

Hi there,

I have to use a rather large lookup-table in my script (2-Dim Array, about 150x200=30000 entries).
The values can be precalculated offline.

My question is: What is the most efficient way for a script to access such a large structure ?

Should I just write this enormous variable into a file and include it in my script (could be a bit of a memory hog 🙂 or is it better to put the values into a database and access by index ?

Any other ideas ?

Thanks,

Daniel

[herve]

Hi,

I think the answer is :

• what do you want do do with those data ? What kind of query ?
• do you already have a RDBMS installed (like Mysql) or not at all ?
• are those data frequently updated or not ?

Hervé.