Updating multiple tables in mssql
Should any right be infringed, it is totally unintentional.Drop me an email and I will promptly and gladly rectify it.Inno DB As you can see the results are very interesting.You can clearly see the difference of both storage engine and transactions (at least for My ISAM).
Suppose we have two tables Categories and Categories_Test. The common column in the two tables is CATEGORY_ID. Please note that query below is used for illustration purpose because Category_ID alone is primary key.
Also, keep in mind that in order to gain advantage of My SQL optimizations all those UPDATE queries need to be run in a batch.
Running each UPDATE query when the page is viewed for example is not the same thing (and that’s pretty much the problem I wanted to solve as efficiently as possible).
Also, as a final note, you should always run an OPTIMIZE TABLE query after all these updates.
update T1 set (the Updated Value, the Other Value) = (select the Top, the Value from T2 where T2Key = T1ID) Is there a workaround?