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!

From:
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
User
Account name:
Password:
If you don't have an account you can create one now.
Subject:
HTML doesn't work in the subject.

Message:

 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

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 Jun. 24th, 2017 05:14 pm
Powered by Dreamwidth Studios