Populating a TEMPORARY table with PHP 1

[webdev007]

How will you envision populating a TEMPORARY TABLE
With existing rows from a non TEMPORARY table?

I am not to sure about the best method.

What is the most efficient way?

Read the existing table in an ARRAY and loop through for inserting or …?

Thanks

 

[feherke]

Hi

What is the most efficient way?

Read the existing table in an ARRAY and loop through for inserting or …?

That is certainly not efficient. Solve it inside the MySQL server, without getting and putting the data :

mysql_query('insert into [green][i]the_temp_table[/i][/green] select * from [green][i]the_table[/i][/green]');

Feherke.

http://rootshell.be/~feherke/

 

[webdev007]

easy enough. Thanks!

 

[webdev007]

I would like adding that it works fine, and is fast.

Plus it addresses a known possible bottle neck effect
that could occur when not making the "select" part of the query, it will work but uses more ressources.