News for hackers. Stuff that matters.
Re:Five Common Rails Mistakes by xentronium on Sunday May 06, 2012 @09:19AM (#3935050)
Do you mean something like this?

    ids = Post.where(:published => true).pluck(:id) 
    Post.where(:id => ids).delete_all
or this

    Post.where(:published => true).delete_all

?
Re:Five Common Rails Mistakes by sanderjd on Sunday May 06, 2012 @12:23PM (#3935482)
The second variant seems much better to me - in the first variant the size of the DELETE query itself is proportional to the number of published posts, so for very large numbers of published posts you'll end up sending a lot of data over the network, and may even hit your max_allowed_packet size (though it defaults to 1GB, which would be a lot of published posts!).
Re:Five Common Rails Mistakes by janus on Sunday May 06, 2012 @09:49AM (#3935115)
You might want to use 'destroy' instead of 'delete', as 'delete' skips all ActiveRecord callbacks (i. e., if you had a dependent: :destroy callback for post comments, using 'delete' would leave them intact)
Re:Five Common Rails Mistakes by xentronium on Sunday May 06, 2012 @10:22AM (#3935178)
`destroy` instantiates active record models which kind of defeats the purpose of fast deletion :)
Re:Five Common Rails Mistakes by janus on Sunday May 06, 2012 @12:11PM (#3935457)
You are right, well in that case, you would have to delete associated records manually if you didn't add any foreign keys at the db level
Re:Five Common Rails Mistakes by chris_wot on Monday May 07, 2012 @05:24AM (#3938292)
I'd suggest deleting or dealing with those records anyway, regardless of whether you added FKs! But... if you don't add FKs, you've got bigger issues to deal with :(
Re:Five Common Rails Mistakes by joevandyk on Sunday May 06, 2012 @02:35PM (#3935870)
this is why i prefer using "on delete cascade" in schemas, no need to transmit lots of data over the wire and instantiate thousands of slow activerecord objects when deleting stuff.
Re:Five Common Rails Mistakes by randomdata on Sunday May 06, 2012 @02:48PM (#3935911)
Though you're still left to deal with your destroy callbacks/observers, if you have any.
Re:Five Common Rails Mistakes by chris_wot on Sunday May 06, 2012 @09:30AM (#3935073)
I looked up the API documentation for pluck... That definitely looks like what I'm talking about :-)

Does the second query translate to a straight DELETE?

Re:Five Common Rails Mistakes by rahoulb on Sunday May 06, 2012 @12:33PM (#3935511)
Yes - `delete from posts where published = 1;` (or however your particular database adapter translates true)