Slash Boxes
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
More | Login | Reply
Loading... please wait.
  • by groditi (7482) on 2007.09.04 12:24 (#57433) Journal
    SELECT cost_net,b.authname AS b_authname, i.authname AS i_authname
    FROM bill b INNER JOIN invoices i USING(invoice)
    WHERE i.affid = 654248 AND b.desctype = 0 AND i.commpaid = 0;

    Now, i think you probably want to have invoice indexed on both sides of the equation, BUT since mysql can only use one index per table I suggest you have an index on i (invoice, affid) and b (invoice)

    I don't know how your tables look with data in them or your other queries, but you should probably have less indexes and more indexes that involve more than one column.