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 per-c
We've recently enabled slow query logging on a server and it's proving
interesting seeing which queries are bogging things down. This one is
puzzling me a little:
SELECT articleid, type, authorid, authorname, text, posted FROM
comments WHERE status = 'normal' ORDER BY posted DESC LIMIT 5;
The p
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
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
