On Wed, 2 May 2007, Tobias Kremer wrote:
I've not quite understood most of this thread, but it sounds like what you
want is:
Table with user1_id, user2_id,
query that returns all user2_id matching a given user_id AND returns all
user1_id that match when user2_is the given user_id.. correct?
I have this with DBIC, no unions involved ;)
Have you tried your approach with a user table that has approximately
250.000 entries? Unfortunately, the resulting LEFT JOIN with OR condition
on this table takes about 10 seconds on my system because MySQL considers
all rows from the user table :( Any ideas on how to optimize this?
Thanx again!
Hmm,m I dont have near as many.. (mebbe 8k), and its fast enough (not on
mysql ;)
When asking this sort of question it's probably clever if you dump the SQL
that DBIC produced into your email.
Jess
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
