פייקון ישראל 2024

עברת לעבוד בעברית. התמיכה עדיין חלקית מאוד, הטפסים לא מתורגמים, וייתכנו שגיאות מערכת, אבל אפשר לכתוב מימין לשמאל, ואנחנו על זה. אם נתקלת בשגיאה, אפשר בדרך כלל לחזור צעד אחורה, לעבור לאנגלית ולהשלים את הפעולה.

How to Make Your Backend Roar
16/09, 14:00–14:20 (Asia/Jerusalem), אולם ראשי (30)
Language: עברית

Developers who are not familiar with databases often dread them and treat them like blackboxes, but fear no more! In this talk I present advanced indexing technics to make your database faster and more efficient.


Indexes are extremely powerful and ORMs like Django and SQLAlchemy provide many ways of harnessing their powers to make queries faster and the database more efficient. In this talk I reveal the secrets of DBAs with some advanced indexing techniques such as partial, function based and inclusive B-Tree indexes, and who knows, maybe even some index types you never heard of before!


Expected experience level of participants

Intermediate

Target audience

Developers

Haki is a software developer and a technical lead. He takes special interest in databases, web development, software design and performance tuning. Haki also writes about development and performance in his blog hakibenita.com.