need some advice: Array or Select from DB

enterume

I need some advice, based on senario below:

Senario : I need to select around 1k(or 10k) records from tableA. One/some of the fields i need to change the original values, which refer to TableB and TableC particular fields value.

Method 1: Pre-Store all the information at TableB and TableC as array, before listing in TableA. When listing out records from tableA, I just refer the column value from the 2 array.

Method 2:I will use seperate SQL statement to select out the column value for each records, when listing in TableA.

Which method do you recommend?

Thank
Louis

halojoy

Info:

We have a Database forum, in PHP Help
Even if I think name of that forum should better be:

mySQL problems bugs and errors

I just wonder, isnt your question about database?
I do not know howto make TableB and TableC in php ....
Never done this 😕

enterume

Originally posted by halojoy
Info:

We have a Database forum, in PHP Help
Even if I think name of that forum should better be:

mySQL problems bugs and errors

I just wonder, isnt your question about database?
I do not know howto make TableB and TableC in php ....
Never done this 😕

May be i should post at MySql section, but this is not 'bugs nor errors'.

for your info, I can preload the reference field in tableB and tableC into array, ins't it?

My question is, which method is more effiecient, and 'do the things right' .

leatherback

This is a general help forum, so 'anything re. PhP goes'. Halojoy: If you do not know an answer, you do not need top reply to it!? If you consider databases useless things, that's fine. But some people like to use them.

just my 2ct

Anyway.. here it goes:

Can you in some way link the info from the three tables? Is there a common colum. In that case, you can use a "Join" to retrieve info from all the tables simultaneously.