Re: Subset Query Speed Help from .46 second to 7 minutes!

[Felix Geerinckx]

Brian Pilati wrote:

> Hope that helps ... looks Greek to me. :)

I must admit that I don't have enough time to go through it in detail at the moment.
But at first sight, your query 3 might benefit from the following additional indexes:

ALTER TABLE general_ledger ADD INDEX index3 (general_ledger_id);
ALTER TABLE invoices ADD INDEX index2 (date_posted);

--
felix
Please use BBCode to format your messages in this forum.