Timeline for MySQL - Many UPDATEs to run after INSERT
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 4, 2018 at 4:46 | comment | added | Rick James | @Mr_Thomas - 3 is unacceptable for a trivial update. What indexes do you have on the tables? Are there 99 more updates? | |
| Apr 17, 2018 at 15:26 | vote | accept | Mr_Thomas | ||
| Apr 17, 2018 at 15:26 | comment | added | Mr_Thomas | Yes (in this example) the Area_Code is unique. I made it a Primary Key and re-wrote the statements like you suggested. 30 seconds down to 3! More than acceptable. | |
| Apr 17, 2018 at 14:15 | history | answered | Dave Poole | CC BY-SA 3.0 |