We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine
Log In Sign Up

Please index the parent_id field of exp_categories by default

Development and Programming

Alphawolf's avatar
Alphawolf
2 posts
4 years ago
Alphawolf's avatar Alphawolf

Can you add an index on the parent_id column for table exp_categories by default? It will speed up queries for categories tremendously.

       
Tom Jaeger's avatar
Tom Jaeger
228 posts
4 years ago
Tom Jaeger's avatar Tom Jaeger

Thanks for posting this. I agree sounds like something we should do. Any chance you would be willing to create a github issue for it?

Thanks, -Tom Jaeger

👍 1
       
Tom Jaeger's avatar
Tom Jaeger
228 posts
4 years ago
Tom Jaeger's avatar Tom Jaeger

I went ahead and opened this issue on github

👍 1
       
Alphawolf's avatar
Alphawolf
2 posts
4 years ago
Alphawolf's avatar Alphawolf

Great!

       
Tom Jaeger's avatar
Tom Jaeger
228 posts
4 years ago
Tom Jaeger's avatar Tom Jaeger

Just as a quick update for anyone following along. This has been fixed and released (I believe in 6.0.2)

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.