PEAK XOOPS - Re: performance enhancements 
Re: performance enhancements
Re: performance enhancements
msg# 1.1
- depth:
- 1
GIJOE
Posts: 4110
Posts: 4110
hi Nick.
Your post sounds quite interesting.
`date` field, ok.
It's just a missing.
I'll add the index.
Quote:In my evironment(MySQL 3.23.58), just adding the index for date raise the query speed enough.
Adding 'USE INDEX (`date`)' after myalbum_photos on FROM section changes nothing.
Which version of MySQL do you use?
Anyway I'll modified SQLs.
Thanks a lot!
Your post sounds quite interesting.
`date` field, ok.
It's just a missing.
I'll add the index.
Quote:
I added an index on the date field but mysql still insisted on using the index on the status column, so I added "USE INDEX(date)" after the photos table. This gave a dramatic performance improvement.
Adding 'USE INDEX (`date`)' after myalbum_photos on FROM section changes nothing.
Which version of MySQL do you use?
Anyway I'll modified SQLs.
Thanks a lot!
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