PEAK XOOPS - Re: performance enhancements 
Re: performance enhancements
Re: performance enhancements
msg# 1.1.1.1
- depth:
- 3
GIJOE
Posts: 4110
Posts: 4110
hi Nick.
Quote:In the online reference of MySQL:
"USE INDEX" does not affect the speed about ORDER section.
But I believe you because you've checked the performance experimentally.
Quote:I've already checked.
But explain just returns "Using filesort ..." in any conditions
It can be the version specific problem.
I've just added your code (modify sql/myalbum*.sql, index.php, viewcat.php).
It will be released later.
Quote:
Thanks for your reply. Our production server is running MySQL 4.0.26 but I have tested the queries on 4.1 and 5.0. For some reason on 4.0 and 4.1 the optimizer uses the status index which is next to useless due to the low cardinality. If you include the "USE INDEX(date)" in the queries it will have no adverse affects on the servers which get it correct.
"USE INDEX" does not affect the speed about ORDER section.
But I believe you because you've checked the performance experimentally.
Quote:
If you run an EXPLAIN on both versions of the query you will see what I mean.
But explain just returns "Using filesort ..." in any conditions
It can be the version specific problem.
I've just added your code (modify sql/myalbum*.sql, index.php, viewcat.php).
It will be released later.
Votes:0
Average:0.00
Posts tree
-
performance enhancements
(nicholsonn, 2006/8/11 23:38)
-
Re: performance enhancements
(GIJOE, 2006/8/12 18:34)
-
Re: performance enhancements
(nicholsonn, 2006/8/13 1:38)
-
Re: performance enhancements
(GIJOE, 2006/8/13 6:08)
-
Re: performance enhancements
(nicholsonn, 2006/8/13 7:39)
-
-
-
-
Login