[et_pb_section fb_built=”1″ specialty=”on” disabled_on=”on|on|on” admin_label=”Section” _builder_version=”4.18.0″ _module_preset=”default” width=”100%” max_width=”100%” custom_padding=”0px||0px||false|false” disabled=”on” ab_subject=”on” ab_subject_id=”1″ locked=”off” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”3_4″ specialty_columns=”3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][/et_pb_column][/et_pb_section][et_pb_section fb_built=”1″ specialty=”on” _builder_version=”4.20.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”2_3″ specialty_columns=”2″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_row_inner module_class=”top-row-res” _builder_version=”4.20.4″ _module_preset=”default” width=”100%” max_width=”100%” custom_padding=”23px||19px|||” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”April 23-25, 2024″ use_icon=”on” font_icon=”||fa||400″ icon_color=”#00162b” icon_placement=”left” image_icon_width=”20px” content_max_width=”100%” admin_label=”Event Date” _builder_version=”4.24.1″ _module_preset=”default” header_font=”||||||||” header_font_size=”14px” image_icon_custom_margin=”0px|0px|0px|0px|true|true” image_icon_custom_padding=”0px|0px|0px|0px|true|true” max_width=”100%” module_alignment=”left” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][/et_pb_blurb][et_pb_blurb title=”Chicago, IL” use_icon=”on” font_icon=”||divi||400″ icon_color=”#00162b” icon_placement=”left” image_icon_width=”20px” content_max_width=”100%” admin_label=”Event Location” _builder_version=”4.24.1″ _module_preset=”default” header_font=”||||||||” header_font_size=”14px” image_icon_custom_margin=”0px|0px|0px|0px|true|true” image_icon_custom_padding=”0px|0px|0px|0px|true|true” max_width=”100%” module_alignment=”left” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][/et_pb_blurb][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner admin_label=”Row” _builder_version=”4.18.0″ _module_preset=”default” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” custom_padding=”|0px||||” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]
David Stokes (Technical Evangelist, Percona) will be presenting 2 talks at PHP[TEK] 2024 on April 23-25, 2024.
EXPLAIN – The Best And Worst Tool For Speeding Up SQL Queries
Structured Query Language can be tricky. The main tool that is used to check query performance is EXPLAIN. EXPLAIN is beyond tricky, having its own little quirks and foibles. This is an introductory session into its use with MySQL and PostgreSQL where you will learn to decipher what EXPLAIN is trying to tell you. EXPLAIN is a handy tool once you learn how to read the entrails.
Seven Database Query Sins You Are Going To Hell For And How To Earn Redemption
Writing good Structured Query Language queries takes effort. But you don’t have the time so you use ‘SELECT * FROM foo’ and as your data grows so does your query time. Or, you have a series of queries that could be run in a batch but run one at a time in a transaction and can not determine why your server is slow. These common problems and others are easy to fix if you know what is wrong and how to fix it. In this session you will see the big seven query sins and understand how to fix them.
About the event.
PHP[TEK] 2024 combines leadership, expertise, and networking in one event. A relaxing atmosphere for tech leaders and developers to share, learn and grow professionally while also providing you with the knowledge to solve your everyday problems
[/et_pb_text][et_pb_button button_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoiY3VzdG9tX21ldGFfZXZlbnRfbGluayIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiIiwiZW5hYmxlX2h0bWwiOiJvZmYifX0=@” url_new_window=”on” button_text=”Go to event link” admin_label=”Event Link” _builder_version=”4.24.1″ _dynamic_attributes=”button_url” _module_preset=”default” custom_button=”on” button_text_size=”14px” button_text_color=”#FFFFFF” button_bg_color=”#00162B” button_border_width=”0px” button_icon=”||fa||900″ button_icon_placement=”left” button_on_hover=”off” custom_padding=”5px|15px|5px|35px|false|false” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][/et_pb_button][/et_pb_column_inner][/et_pb_row_inner][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_post_title title=”off” meta=”off” admin_label=”Event Thumbnail” _builder_version=”4.23.4″ _module_preset=”default” global_colors_info=”{}”][/et_pb_post_title][/et_pb_column][/et_pb_section]
