SQLite for beginners: Fixing Slow Queries

Did you know that SQLite offers profiling tools to help you identify the cause of slow queries? There's even a tool that suggests indexes you should add to improve a query's performance.
Watch this video to learn more.
mycelial.com/#...
/ mycelial
github.com/myc...
/ discord

[@ondrejvodicka3900]

Thank you very much! This video helped me tremendously!

[@rccar354]

Very insightful educator ... thankyou things that come-to-mind... how to implement this in a dll, how to start AI functions for database searching in 2 and three dimensions and how to implement some of these searches in Lazarus or Delphi, and/or MinGW in Eclipse-CDT for win10 on 64-bit for example to help one consider how one might hold a pair of tweezers to hold something most effectively, and, to balance speed and outcome [ starting and stopping/heating loads] with regard to the current Earth's magnet field if Shrodingers equation is not a constant but a variable. eg in JET AIRCRAFT and/or space craft GIVING MATHS and PHYSICS a 'SUSPENSION SYSTEM' assuming that time and gravity interact.... among other things this also makes me think about gallium telluride in cooling circuits - I am currently working on developing a unicode dual text editor to facilitate learning Greek and hopefully, eventually other ancient languages like Ancient Egyptian Hieroglyphics etc. I am a newbie who tries to think outside the square.

[@pr0skis]

👍