#queryoptimization — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #queryoptimization, aggregated by home.social.
-
Want faster, high‑quality results from Vertex AI Search? Learn how to fine‑tune queries, trim latency, and keep relevance sharp—all while respecting IAM and leveraging generative AI for smarter document indexing. Boost your search performance on Google Cloud today. #VertexAISearch #QueryOptimization #LatencyReduction #SearchPerformance
🔗 https://aidailypost.com/news/optimizing-vertex-ai-search-queries-cut-latency-preserve-quality
-
Want faster, high‑quality results from Vertex AI Search? Learn how to fine‑tune queries, trim latency, and keep relevance sharp—all while respecting IAM and leveraging generative AI for smarter document indexing. Boost your search performance on Google Cloud today. #VertexAISearch #QueryOptimization #LatencyReduction #SearchPerformance
🔗 https://aidailypost.com/news/optimizing-vertex-ai-search-queries-cut-latency-preserve-quality
-
📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘
-
📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘
-
SQL doesn’t run by magic. Your query travels through the network layer, gets parsed, optimized, executed, and finally hits storage with locks, buffers, and transactions managing every step. Knowing this makes you a faster, smarter analyst.
#SQL #Databases #QueryOptimization #DataEngineering #BackendSystems #BigData #TechSkills
-
SQL doesn’t run by magic. Your query travels through the network layer, gets parsed, optimized, executed, and finally hits storage with locks, buffers, and transactions managing every step. Knowing this makes you a faster, smarter analyst.
#SQL #Databases #QueryOptimization #DataEngineering #BackendSystems #BigData #TechSkills
-
Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.
🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance
-
Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.
🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance
-
Seeing slow queries + table bloat? Start with VACUUM to clear dead tuples, add ANALYZE to refresh stats, then consider VACUUM FULL only if you must. #PostgreSQL #QueryOptimization
https://til.sanyamkhurana.com/#/topics/psql/vacuum-analyze-in-postgresql -
🧑💻 Ah, the thrilling world of #SQL #heuristics, where ORs are the villains and ANDs save the day! 🚀 Apparently, turning "ORs" into "ANDs" is the secret sauce to slashing query time from a snail-paced 100ms to a lightning-fast 1ms. Who knew the key to #performance was just a matter of playing word games? 🎉
https://ethanseal.com/articles/ors-are-expensive #Optimization #QueryOptimization #TechTips #DatabaseEfficiency #HackerNews #ngated -
🧑💻 Ah, the thrilling world of #SQL #heuristics, where ORs are the villains and ANDs save the day! 🚀 Apparently, turning "ORs" into "ANDs" is the secret sauce to slashing query time from a snail-paced 100ms to a lightning-fast 1ms. Who knew the key to #performance was just a matter of playing word games? 🎉
https://ethanseal.com/articles/ors-are-expensive #Optimization #QueryOptimization #TechTips #DatabaseEfficiency #HackerNews #ngated -
Nice:
“Extensible Query Optimizers In Practice” [2024, PDF], Bailu Ding, et al (https://www.microsoft.com/en-us/research/uploads/prod/2024/12/Extensible-Query-Optimizers-in-Practice.pdf).
#RDBMS #DB #QueryOptimizer #Paper #eBook #Survey #Databases #QueryOptimization
-
Nice:
“Extensible Query Optimizers In Practice” [2024, PDF], Bailu Ding, et al (https://www.microsoft.com/en-us/research/uploads/prod/2024/12/Extensible-Query-Optimizers-in-Practice.pdf).
#RDBMS #DB #QueryOptimizer #Paper #eBook #Survey #Databases #QueryOptimization
-
Sentinel Holiday Time Tip - Optimize Query Performance: Use best practices to optimize the performance of your KQL queries. Efficient queries reduce resource consumption and improve response times while controlling SIEM costs. #QueryOptimization #Performance #Efficiency
-
How to improve database performance from DesignGurus.io? Forgot who is the author … discovered it on the @LinkedIn a couple of days ago … Because the original *GIF* file but shows the static image on the #WeChat moment I have to share it via a small *MP4* file on the #WeChat channel …
#RDBMS #Database #PerformanceTuning #Indexing #MaterializedViews #VerticalScaling #Denormalization #Caching #Replication #Sharding #Partitioning #QueryOptimization
-
How to improve database performance from DesignGurus.io? Forgot who is the author … discovered it on the @LinkedIn a couple of days ago … Because the original *GIF* file but shows the static image on the #WeChat moment I have to share it via a small *MP4* file on the #WeChat channel …
#RDBMS #Database #PerformanceTuning #Indexing #MaterializedViews #VerticalScaling #Denormalization #Caching #Replication #Sharding #Partitioning #QueryOptimization
-
“Why SQLite Uses Bytecode”, D. Richard Hipp (https://sqlite.org/draft/whybytecode.html).
On HN: https://news.ycombinator.com/item?id=40206752
On Lobsters: https://lobste.rs/s/g2tl3w/why_sqlite_uses_bytecode
#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL
-
“Why SQLite Uses Bytecode”, D. Richard Hipp (https://sqlite.org/draft/whybytecode.html).
On HN: https://news.ycombinator.com/item?id=40206752
On Lobsters: https://lobste.rs/s/g2tl3w/why_sqlite_uses_bytecode
#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL
-
Struggling to get detailed insight into your #DNS query volume at your current DNS provider 🧐? You need better transparency. DNSimple's new API endpoint tells you how many DNS queries your domains are receiving per-day, per-zone 📊 . Read our latest post
👉 https://blog.dnsimple.com/2024/03/dns-analytics-endpoint/?utm_source=mastodon&utm_medium=social&utm_campaign=dns-analytics-endpoint -
Struggling to get detailed insight into your #DNS query volume at your current DNS provider 🧐? You need better transparency. DNSimple's new API endpoint tells you how many DNS queries your domains are receiving per-day, per-zone 📊 . Read our latest post
👉 https://blog.dnsimple.com/2024/03/dns-analytics-endpoint/?utm_source=mastodon&utm_medium=social&utm_campaign=dns-analytics-endpoint -
Made a YouTube short going over techniques to speed up a Django query 🏃♀️
https://youtube.com/shorts/mewTap8ZQ6w?feature=share
Article with video: https://www.jetbrains.com/guide/python/tips/django-query-speed-up/Seeing the Djangonauts of @djangonaut work on django-debug-toolbar reminded me how great a tool it is 💜
Please like, comment, and subscribe if you like the video, and all feedback is welcome 🦄
#Django #django-debug-toolbar #QueryOptimization
-
Made a YouTube short going over techniques to speed up a Django query 🏃♀️
https://youtube.com/shorts/mewTap8ZQ6w?feature=share
Article with video: https://www.jetbrains.com/guide/python/tips/django-query-speed-up/Seeing the Djangonauts of @djangonaut work on django-debug-toolbar reminded me how great a tool it is 💜
Please like, comment, and subscribe if you like the video, and all feedback is welcome 🦄
#Django #django-debug-toolbar #QueryOptimization
-
“Brave Software developers have created a new privacy-centric database query system called FrodoPIR that retrieves data from servers without disclosing the content of user queries.”
Great to see innovation in this space.
#dataprivacy #privacy #security #data #databases #queryoptimization
-
“Brave Software developers have created a new privacy-centric database query system called FrodoPIR that retrieves data from servers without disclosing the content of user queries.”
Great to see innovation in this space.
#dataprivacy #privacy #security #data #databases #queryoptimization
-
I'm happy to share that we got 2 papers accepted today.
The first one on "Extraction of Validating Shapes from very large Knowledge Graphs" was accepted at #VLDB2023, authors: K. Rabbani, M. Lissandrini, K. Hose
The second one on "Scaling Large RDF Archives To Very Long Histories" was accepted at #ICSC2023, authors: O. Pelgrin, R. Taelman, L. Galàrraga, K. Hose
#knowledgeGraphs #shacl #shapes #queryOptimization #SPARQL #rdf #archiving
-
I'm happy to share that we got 2 papers accepted today.
The first one on "Extraction of Validating Shapes from very large Knowledge Graphs" was accepted at #VLDB2023, authors: K. Rabbani, M. Lissandrini, K. Hose
The second one on "Scaling Large RDF Archives To Very Long Histories" was accepted at #ICSC2023, authors: O. Pelgrin, R. Taelman, L. Galàrraga, K. Hose
#knowledgeGraphs #shacl #shapes #queryOptimization #SPARQL #rdf #archiving
