The Ultimate Guide to High Availability with MariaDB

Comments - WITH

2 years, 11 months ago Gingko Biloba
Re: WITH

Is it normal that, if I define a subquery (a large one with chained WITH) using WITH that takes 500 mS to execute, and I use this subquery 8 times in the main query, the whole set takes 4 seconds (thus 8 times the subquery duration) to execute?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.