Re: [Cloud] Upgrade to MariaDB 10.2

I wanted to follow-up on this question from 10 months ago and ask if there are any plans to upgrade to MariaDB 10.2 or higher Besides CTEs, another important feature added in 10.2 is the windowed functions LEAD() and LAG() On Tue, Jul 17, 2018 at 6:29 PM Huji Lee wrote: > CTEs are not an absolu

Re: [Cloud] Upgrade to MariaDB 10.2

El dom., 2 jun. 2019 17:05, Huji Lee escribió: > I wanted to follow-up on this question from 10 months ago and ask if there > are any plans to upgrade to MariaDB 10.2 or higher > > Besides CTEs, another important feature added in 10.2 is the windowed > functions LEAD() and LAG() > Hello, At the

[Cloud] Toolforge SQL performance issue with new comment table

Hello, Some Toolforge SQL queries have much worse performance when updated for the new comment table. For example, see one previous SQL query

Re: [Cloud] Toolforge SQL performance issue with new comment table

Hey, One important optimization you can use and it's often missed out (and it's going to be needed more as we normalize more tables) is join decomposition. It basically means you don't join and query but do two (or several) queries separately in your code. This might seem counter intuitive but it's

Re: [Cloud] Toolforge SQL performance issue with new comment table

Thanks! Performance is much better with that change. On Sun, 2 Jun 2019 at 21:54, Amir Sarabadani wrote: > Hey, > One important optimization you can use and it's often missed out (and it's > going to be needed more as we normalize more tables) is join decomposition. > It basically means you don

Re: [Cloud] Toolforge SQL performance issue with new comment table

On Sun, Jun 2, 2019 at 7:43 PM Jesse Plamondon-Willard wrote: > > Hello, > > Some Toolforge SQL queries have much worse performance when updated for the > new comment table. > > For example, see one previous SQL query and its updated version which just > adds a join on the comment table. The cha