Brian Pilati wrote:
> With your changes the query is now
> averages under a second. As you predicted. The
> other good news, a query for the last two years
> and a half of invoices and payment runs at 6
> seconds. That rocks. I will make sure I send you
> my bonus! ;)
Glad I could help out a little.
> If you see anything else I should do, please let
> me know.
Nope, that EXPLAIN looks correct, and everything operates expectedly.
> BTW- I tried to pull-up Amazon.com to purchase
> your book and Amazon seems to not be working. I
> have a great interest now in your work. It seems
> you have been able to take queries to another
> level.
Not sure why... If not Amazon, you can try a normal bookstore... though I know Amazon was selling them for a discount. Also, I believe the publisher Apress is selling e-book versions on their website. If that doesn't work, just get in touch with me and I'll figure something out! :)
Cheers,
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com