Cutting down on queries

[Anon]

while( $r = $DB->fetch_row() )
{
// Copy over the previous votes, this is the only way 🙁
$DB->query2("UPDATE tsl_sites SET votes_old='$r[votes]' WHERE id='$r[id]'");
}

That can create, in possibility 100s of queries. How could that be made less?

Code Sample

$DB->query("UPDATE tsl_config SET $fields WHERE id=$DB->sql_id");
$DB->query("UPDATE tsl_sites SET $fields2");

How could I possibly cut down those two queries into one, if possible?

Thankyou smile.gif

[jacks9999]

Depends on the database. With Oracle you could create a prepared statement which would drastically improve performance. With other you could try separating your queries with a ; (semi-colon). Some engines will allow that.

G'luck,

Jack