我应该让php处理它或将所有数据转储到数据库[关闭]

Question

Hi i am using php and mysql on my project and i wanted to know which is better (all aspect).
I am expecting a big amount of data in the database.
I want it to search faster.


Should i store the real value or a reference value.
1) Have php proccess it? Meaning I will store values in the database as integer/tinyint and then create a function to know the value to output. ie. if 1 then value is "north" elseif 2 then value is "east" and so on. values will not change.

let say i will have at least 20 of this function.

database design
id direction
1 1 (1=north)


output (use php to display the output)
north



2) Dump all data to database.

database design
id direction
1 north

Answer 1

Will the data change overtime, or are they fixed?

If the data can change, better store them in database so you don't have to keep changing your PHP code and just update the data in database as needed.

If the data is fixed, then just store it in PHP. Maybe you can just store it as array and access the record as needed.

$data = array (1 => 'i am one', 2 => 'i am two', 3 => 'etc');
echo "{$data[1]}"; // will output 'i am one'