{"guid":"e3375df5-8ff8-425e-b877-213c6a920d78","title":"Faster Analytics with MariaDB 10.2","subtitle":"Advanced SQL features - CTEs and Window Function","slug":"froscon2017-1940-faster_analytics_with_mariadb_10_2","link":"https://c3voc.de","description":"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.\nWith a focus on analytical queries, we will see how to improve query performance sometimes by an order of magnitude compared to regular SQL.\n","original_language":"eng","persons":["Vicențiu Ciorbaru"],"tags":["froscon17","1940"],"view_count":165,"promoted":false,"date":"2017-08-19T00:00:00.000+02:00","release_date":"2017-08-19T02:00:00.000+02:00","updated_at":"2025-07-30T23:15:04.714+02:00","length":2205,"duration":2205,"thumb_url":"https://static.media.ccc.de/media/events/froscon/2017/1940-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/froscon/2017/1940-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/froscon/2017/e3375df5-8ff8-425e-b877-213c6a920d78-timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/froscon/2017/e3375df5-8ff8-425e-b877-213c6a920d78-thumbnails.vtt","frontend_link":"https://media.ccc.de/v/froscon2017-1940-faster_analytics_with_mariadb_10_2","url":"https://api.media.ccc.de/public/events/e3375df5-8ff8-425e-b877-213c6a920d78","conference_title":"FrOSCon 2017","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017","related":[{"event_id":4387,"event_guid":"9910a89c-ce50-4b0d-80a2-930e4bda8574","weight":4},{"event_id":4391,"event_guid":"c2d5346f-bd26-43c3-8c19-bbcdf52cd6e3","weight":8},{"event_id":4393,"event_guid":"726f6dc1-ff55-4bd7-bffa-56ae1a4596fc","weight":3},{"event_id":4401,"event_guid":"ba70ec96-57f0-414a-8850-2b9006e76219","weight":4},{"event_id":4421,"event_guid":"2f2fd9af-2c7f-4eea-bf6c-3e90176f3f75","weight":3},{"event_id":4438,"event_guid":"ef580a50-1dd3-4a9b-aae0-4a440cba9ba4","weight":16},{"event_id":4444,"event_guid":"338b865c-b072-45f1-a8bc-54775999e794","weight":3},{"event_id":4458,"event_guid":"40732b8d-7cd9-4a36-951b-f898872d623a","weight":3},{"event_id":4461,"event_guid":"489dc194-4c5d-45ee-a062-dd6098255ae0","weight":3},{"event_id":4472,"event_guid":"35abdd14-4469-4295-b3d1-0eba9f4015d2","weight":3},{"event_id":4475,"event_guid":"7fe1d23c-263d-4507-a56b-fa77f7700dda","weight":4}],"recordings":[{"size":129,"length":2205,"mime_type":"video/mp4","language":"eng","filename":"froscon17-1940-eng-Faster_Analytics_with_MariaDB_102_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2017-08-19T14:35:38.149+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/h264-hd/froscon17-1940-eng-Faster_Analytics_with_MariaDB_102_hd.mp4","url":"https://api.media.ccc.de/public/recordings/18435","event_url":"https://api.media.ccc.de/public/events/e3375df5-8ff8-425e-b877-213c6a920d78","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"},{"size":23,"length":2198,"mime_type":"audio/opus","language":"eng","filename":"froscon17-1940-eng-Faster_Analytics_with_MariaDB_102.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2017-08-19T14:49:06.122+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/opus/froscon17-1940-eng-Faster_Analytics_with_MariaDB_102.opus","url":"https://api.media.ccc.de/public/recordings/18464","event_url":"https://api.media.ccc.de/public/events/e3375df5-8ff8-425e-b877-213c6a920d78","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"},{"size":33,"length":2198,"mime_type":"audio/mpeg","language":"eng","filename":"froscon17-1940-eng-Faster_Analytics_with_MariaDB_102.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2017-08-19T14:49:49.342+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/mp3/froscon17-1940-eng-Faster_Analytics_with_MariaDB_102.mp3","url":"https://api.media.ccc.de/public/recordings/18467","event_url":"https://api.media.ccc.de/public/events/e3375df5-8ff8-425e-b877-213c6a920d78","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"},{"size":146,"length":2205,"mime_type":"video/webm","language":"eng","filename":"froscon17-1940-eng-Faster_Analytics_with_MariaDB_102_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2017-08-19T16:35:27.275+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/webm-hd/froscon17-1940-eng-Faster_Analytics_with_MariaDB_102_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/18500","event_url":"https://api.media.ccc.de/public/events/e3375df5-8ff8-425e-b877-213c6a920d78","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"},{"size":54,"length":2205,"mime_type":"video/webm","language":"eng","filename":"froscon17-1940-eng-Faster_Analytics_with_MariaDB_102_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2017-08-19T16:43:41.551+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/webm-sd/froscon17-1940-eng-Faster_Analytics_with_MariaDB_102_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/18507","event_url":"https://api.media.ccc.de/public/events/e3375df5-8ff8-425e-b877-213c6a920d78","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"},{"size":52,"length":2205,"mime_type":"video/mp4","language":"eng","filename":"froscon17-1940-eng-Faster_Analytics_with_MariaDB_102_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2017-08-19T16:44:19.430+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/h264-sd/froscon17-1940-eng-Faster_Analytics_with_MariaDB_102_sd.mp4","url":"https://api.media.ccc.de/public/recordings/18508","event_url":"https://api.media.ccc.de/public/events/e3375df5-8ff8-425e-b877-213c6a920d78","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"}]}