> * Tobias Kremer <[EMAIL PROTECTED]> [070502 09:10]: > > 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? > > Have you created an index for each of the user id columns?
Of course :) The problem is rather the left join (with OR condition) on the user table (not the where condition on the friendship table). --Tobias _______________________________________________ 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/dbix-class@lists.rawmode.org/
