Brynjolfur Thorvardsson wrote in post #1037658: > (SELECT uid2 AS uid, status FROM friendships WHERE uid1 = 1) > UNION > (SELECT uid1,status FROM friendships WHERE uid2 = 1)
It works fine, but it is slow :( Only one entry per friendship (1 500 000 rows in database) SELECT with UNION: 1.2108 sek Dublicate entryes ( total 3 000 000 rows in database) SELECT without UNION: 0.0007 sek -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
