{"guid":"9144aaee-4cb6-4497-89d9-acca7da85730","title":"Volkskrankheit \"stiefmütterliche SQL-Indizierung\"","subtitle":"Live-Quiz: kennst du die häufigsten SQL-Performance-Sünden?","slug":"froscon2018-2143-volkskrankheit_stiefmutterliche_sql-indizierung","link":"https://programm.froscon.de/2018/events/2143.html","description":"SQL-Indizierung gehört zur Softwareentwicklung. Warum Entwickler den Kopf nicht länger in den Sand stecken sollten zeigt dieser Vortrag.\n\nDieser Vortrag geht kurz auf die häufigste Ursache schlechter SQL-Performance ein – die Index/Query-Inkompatibilität – und erklärt, wie es dazu kommen konnte. Der Hauptteil des Vortrages widmet sich der Lösung dieses Problems auf äußerst unterhaltsame Weise: In einem Live-Quiz mit dem Publikum werden die wichtigsten Beispiele der Index/Query-Inkompatibilität demonstriert und gezeigt, wie sich die Performance mit einfachen Mitteln um Faktoren verbessern lässt.","original_language":"deu","persons":["Markus Winand"],"view_count":298,"promoted":false,"date":"2018-08-26T00:00:00.000+02:00","release_date":"2018-08-26T02:00:00.000+02:00","updated_at":"2026-04-10T15:30:05.880+02:00","tags":["froscon2018","2143","Databases"],"length":3805,"duration":3805,"thumb_url":"https://static.media.ccc.de/media/events/froscon/2018/2143-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/froscon/2018/2143-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/froscon/2018/9144aaee-4cb6-4497-89d9-acca7da85730-timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/froscon/2018/9144aaee-4cb6-4497-89d9-acca7da85730-thumbnails.vtt","frontend_link":"https://media.ccc.de/v/froscon2018-2143-volkskrankheit_stiefmutterliche_sql-indizierung","url":"https://api.media.ccc.de/public/events/9144aaee-4cb6-4497-89d9-acca7da85730","conference_title":"FrOSCon 2018","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018","related":[{"event_id":5734,"event_guid":"adde2800-ffa1-44c4-aafd-c4928ee5378d","weight":12},{"event_id":5735,"event_guid":"d494138e-2442-4b08-b06b-43e1aa444701","weight":9},{"event_id":5736,"event_guid":"73bbeee4-7791-42d2-b3bd-317ca12a8895","weight":11},{"event_id":5738,"event_guid":"fafacf91-9842-4a5f-bb02-146250450001","weight":10},{"event_id":5740,"event_guid":"325decd8-4e17-42d1-aab7-446e7651a617","weight":9},{"event_id":5751,"event_guid":"2b7d1c38-d3e0-4978-ac30-95aed9e7b0d7","weight":15},{"event_id":5758,"event_guid":"ef2ff203-e91d-4b8f-90ad-966fe74d5325","weight":4},{"event_id":5763,"event_guid":"e7828a90-6f0a-439b-a6a8-2e129a00b521","weight":7},{"event_id":5766,"event_guid":"73f1dcb2-25ba-48ff-a02a-3abc33360f03","weight":12},{"event_id":5773,"event_guid":"be056c9c-b6f6-42a3-adb1-0d6e80a1f4c7","weight":9},{"event_id":5778,"event_guid":"c18d8138-d063-4f42-a5ba-d48c9e617714","weight":3},{"event_id":5780,"event_guid":"62e8df5f-cd0b-4606-8d61-18b274e1d048","weight":14},{"event_id":5782,"event_guid":"2596a0ad-f2a4-403b-9d79-1398c4f72e53","weight":10},{"event_id":5789,"event_guid":"b4cb8731-0709-4c3e-967b-3766a15ea572","weight":27},{"event_id":5793,"event_guid":"05d2f707-19a8-491d-a375-13280c771034","weight":4},{"event_id":5797,"event_guid":"b72de5fc-3cd1-4a76-980c-ca48bac7184f","weight":3},{"event_id":5809,"event_guid":"68e5d6b9-b0cb-4317-b724-5f45145c7eba","weight":14},{"event_id":5811,"event_guid":"b9affdeb-41c2-4322-8a5a-1c7676372ea9","weight":8},{"event_id":5818,"event_guid":"f730ef2e-a133-4174-ae95-3d7c012b4b09","weight":9},{"event_id":5830,"event_guid":"1f3a0237-0515-4cdb-90ac-d57f7bc85586","weight":11}],"recordings":[{"size":234,"length":3805,"mime_type":"video/mp4","language":"deu","filename":"froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2018-08-26T13:05:05.382+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/h264-hd/froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_hd.mp4","url":"https://api.media.ccc.de/public/recordings/27358","event_url":"https://api.media.ccc.de/public/events/9144aaee-4cb6-4497-89d9-acca7da85730","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"},{"size":47,"length":3798,"mime_type":"audio/opus","language":"deu","filename":"froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2018-08-26T13:17:36.574+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/opus/froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_opus.opus","url":"https://api.media.ccc.de/public/recordings/27370","event_url":"https://api.media.ccc.de/public/events/9144aaee-4cb6-4497-89d9-acca7da85730","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"},{"size":57,"length":3798,"mime_type":"audio/mpeg","language":"deu","filename":"froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2018-08-26T13:18:01.544+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/mp3/froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/27371","event_url":"https://api.media.ccc.de/public/events/9144aaee-4cb6-4497-89d9-acca7da85730","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"},{"size":133,"length":3805,"mime_type":"video/webm","language":"deu","filename":"froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2018-08-26T13:36:38.596+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/webm-sd/froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/27382","event_url":"https://api.media.ccc.de/public/events/9144aaee-4cb6-4497-89d9-acca7da85730","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"},{"size":322,"length":3805,"mime_type":"video/webm","language":"deu","filename":"froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2018-08-26T14:05:32.710+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/webm-hd/froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/27392","event_url":"https://api.media.ccc.de/public/events/9144aaee-4cb6-4497-89d9-acca7da85730","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"},{"size":102,"length":3805,"mime_type":"video/mp4","language":"deu","filename":"froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2018-08-26T15:22:54.193+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/h264-sd/froscon2018-2143-deu-Volkskrankheit_stiefmuetterliche_SQL-Indizierung_sd.mp4","url":"https://api.media.ccc.de/public/recordings/27441","event_url":"https://api.media.ccc.de/public/events/9144aaee-4cb6-4497-89d9-acca7da85730","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"}]}