Faster Analytics with MariaDB 10.2 (froscon2017)

36:45
 
Share
 

Manage episode 197906619 series 1910928
By Discovered by Player FM and our community — copyright is owned by the publisher, not Player FM, and audio streamed directly from their servers.
MariaDB 10.2 has brought two new important querying features, Common Table Expressions (CTEs) and Window Functions. Both features provide greater expressibility to queries, thus opening up opportunities for the optimiser to provide speedups not previously achievable. With a focus on analytical queries, we will see how to improve query performance sometimes by an order of magnitude compared to regular SQL. about this event: https://c3voc.de

5307 episodes available. A new episode about every 11 hours averaging 29 mins duration .