Stories
Slash Boxes
Comments
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.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • by groditi (7482) on 2007.09.04 12:23 (#57432) 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.