warthog9: Warthog9 (Default)
[personal profile] warthog9
 So I've been spending a lot of time re-working this database backed website, and I'm moving towards it going 'live' so I've got a copy of the database and I'm running the modifcations.  One of the queries I had goes something like this:

mysql> -- This will likely take something like 5 minutes?
mysql> update table1,table2 set table1.guilty_id = table2.id where table1.guilty = table2.name;
Query OK, 3128414 rows affected (1 day 9 hours 14 min 53.02 sec)
Rows matched: 3128414  Changed: 3128414  Warnings: 0

Something tells me the first time I ran that query, and it took only 5 minutes, was a fluke!

Profile

warthog9: Warthog9 (Default)
warthog9

December 2014

S M T W T F S
 123456
78910111213
141516 17181920
21222324252627
28293031   

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Aug. 24th, 2017 04:56 am
Powered by Dreamwidth Studios