![]() Preserved Topic: 300X MySQL Performance Increase (Page 1 of 1) |
|
---|---|
Paranoid (IV) Inmate From: Minneapolis, MN, USA |
![]() Holy cow. I used to have a caching system on my events calendar because it was taking 30+ seconds to generate a page. Then I noticed that the page generates in under 2 seconds while generating the exact same page with an expanded WHERE query. |
Paranoid (IV) Mad Scientist From: Omicron Persei 8 |
![]() you wanna increase it even more? add CLUSTERS to your INDEXES. |
Paranoid (IV) Inmate From: Minneapolis, MN, USA |
![]() Do you mean like creating indexes of multiple columns? |
Paranoid (IV) Mad Scientist From: Omicron Persei 8 |
![]() uh, sorry i dont know the details. |
Paranoid (IV) Mad Scientist From: Somewhere over the rainbow |
![]() The poster has demanded we remove all his contributions, less he takes legal action. |
Paranoid (IV) Inmate From: Minneapolis, MN, USA |
![]() Grumble- I saw no mention of CLUSTERs on that page you pointed to, but I think it applies to Oracle and not MySQL anyway. |
Paranoid (IV) Mad Scientist From: Somewhere over the rainbow |
![]() The poster has demanded we remove all his contributions, less he takes legal action. |
Paranoid (IV) Inmate From: Minneapolis, MN, USA |
![]() I forget where I read this, but somewhere in the MySQL manual it talks about the length of fields, and how certain optimizations can only be made when different fields are the same length (perhaps multi-column indexes should go over same-length fields). |
Paranoid (IV) Mad Scientist From: Omicron Persei 8 |
![]() yea, jiblet. you might be right about the oracle thing. we here use an oracle 8 db and use clusters. |