Query Optimisation/Design Problem

2005-02-20 Thread Andreas Ahlenstorf
Hi, I have to implement a bestseller list feature into a shop software and, unfortunately, I don't see a possibility to make it as fast as it has to be. The relevant stuff is distributed among four tables [1]. `orders` contains all the ordered products. I use the following query to create a

re: query optimisation

2003-02-28 Thread Egor Egorov
On Friday 28 February 2003 05:22, Dan Rossi wrote: hi there i was wondering if there was a must get mysql book or paper covering query optimisation ? Some info you can find in the manual: http://www.mysql.com/doc/en/MySQL_Optimisation.html And look also at Paul DuBois book MySQL

query optimisation

2003-02-27 Thread Dan Rossi
hi there i was wondering if there was a must get mysql book or paper covering query optimisation ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list