关联变量及其ID的最佳方法

Question

I am getting results from a database with a simple php while loop, one of the pieces of information is a number that links to another table where the value is stored, I can think of plenty of ways to get this information linked and display the text related to the value but I want to know the fastest way to do it as I have a huge set of results so every bit of speed will make a difference. Is an array fastest, javascript? any advice you can give me would be great.

The schema would look something like this

col_table 
colID(autonumber) colName(str) colState(int) colDate(date) 

state_table
stateID(int) stateType(str)

I want to select the correct state type based on the colState matching a stateID and output the stateType while preserving the stateID for so I can edit the field and update the database using the number.

Answer 1

Using MySQL will be faster. If you have to get through a PHP loop to read your results and make each time a new MySQL request, your script will take longer.

You can increase speed on MySQL by creating the right kind/amount of index, choosing wisely what is store in each field.

The later you parse content, the longer it will take. If you go for js, you will have to read a DB, loop trough it in PHP and do it again in JS, and making more request again ...

A join can be a good solution. A view can be even more easier to treat. Yuo can also consider caching results