#SQLPerformance

Pure Tech

@puretech.news

3 months ago

Is JOIN Faster Than Correlated Subqueries? Taking a Look and Subsequently Debunking the Myth Hey there, fellow developers! If you've ever dabbled in SQL, you've probably heard the golden rule:

Is JOIN Faster Than Correlated Subqueries? Taking a Look and Subsequently Debunking the Myth #Technology #SoftwareEngineering #Other #SQLPerformance #DatabaseOptimization

LLMs

@llms.activitypub.awakari.com.ap.brid.gy

4 months ago

Weekly #45-2025: PHP Tricks, LLM Collaboration, SQL Speedups, and the Future of Web Payments In this week’s edition of Madhu Sudhan Subedi Tech Weekly, we explore the hidden risks of dynamic method calls in PHP, the evolving role of developers as non-engineers start coding with LLMs, and how smart indexing can supercharge SQL performance. We also share lessons beyond code for new programmers and dive into the revival of HTTP 402, showing how agentic payments could reshape the web economy. Stay ahead with insights on practical coding, team collaboration, database optimization, and the future of digital transactions.

Weekly #45-2025: PHP Tricks, LLM Collaboration, SQL Speedups, and the Future of Web Payments 🔊 Listen Now 🎙️ Click here to listen on Madhu Sudhan Subedi Tech Weekly → Dynamic Method Calls...

#phpdevelopment #aiandllms #sqlperformance #webpayments

Origin | Interest | Match

@podparley.bsky.social

4 months ago

🎧 Scaling Postgres
Heavy Reader or Writer? | Scaling Postgres 389 (14min)
Listen
Details
#PostgresScaling #DatabaseOptimization #SQLPerformance

Data Egret GmbH

@dataegret.bsky.social

4 months ago

High Performance SQL with Postgres​ - Data Egret <- Back to all courses High Performance SQL with Postgres Advanced Course for Developers 🗓️ Course dates: 1–10 December 2025   Deep-dive course by the recognised PostgreSQL contributing...

🚀 Developers — want to make PostgreSQL fly?
Our High Performance SQL course (1–10 Dec) focuses on writing efficient queries, indexing and anti-patterns and common mistakes in SQL development.
👉 Enroll: dataegret.com/high-perform...
#SQLPerformance #PostgreSQL #DeveloperTraining

Jeff Taylor

@reviewmydb.bsky.social

6 months ago

[Blog] SQL Server 2025 Backup Compression and Restore Review

Check out my blog post reviewing each compression level, backup size, and backup and restore times in SQL Server 2025

www.jefftaylor.io/post/sql-ser...

#SQLServer #ZSTD #SQLServer2025 #SQLBackups #DatabaseCompression #SQLPerformance

Jeff Taylor

@reviewmydb.bsky.social

7 months ago

[Blog] SQL Server 2025 Backups - New ZSTD Compression

Check out the new built-in compression ZStandard in SQL Server 2025!

www.jefftaylor.io/post/sql-ser...

#SQLServer #Azure #ZSTD #SZtandard #Facebook #SQLServer2025 #SQLBackups #DatabaseCompression #SQLPerformance

Zahid07

@zahid07.bsky.social

8 months ago

You will get database design normalization ERD with visio or lucid chart Get database design normalization ERD with visio or lucid chart from Upwork Freelancer MD ZAHEDUL I.

🟢 View my Upwork profile here: www.upwork.com/services/pro...

#UpworkDeveloper, #FreelanceDatabase, #SQLHelp, #DatabaseExpert, #HireFreelancer, #MySQLDeveloper, #PostgreSQLExpert, #SQLPerformance, #ETLSolutions, #DataCleaning, #SQLQueries, #DatabaseConsulting, #TechFreelancer,

Pure Tech

@puretech.news

10 months ago

Best Practices for Faster Queries: A SQL Performance Tuning Tutorial Introduction Efficient SQL queries are essential for optimal performance in Oracle databases. This article focuses on key practices for query optimization, with practical examples tailored for Oracle...

Best Practices for Faster Queries: A SQL Performance Tuning Tutorial #Technology #SoftwareEngineering #DatabaseOptimization #SQLPerformance

MariaDB

@mariadb.bsky.social

1 year ago

ANALYZE example in MariaDB

Visualize query execution plans in JSON format with ANALYZE FORMAT=JSON! Perfect for deeper insights. 🛠️
mariadb.com/kb/en/analyz...
#MariaDB #SQLPerformance #QueryTuning

Firebolt

@firebolthq.bsky.social

1 year ago

Are redundant computations slowing down your queries? ⏱️

Firebolt’s subresult reuse eliminates re-executing identical query segments by storing and reusing them across sessions. Cut compute overhead and speed up performance under heavy workloads.

👉 bit.ly/3ZWr4pj

#DataEngineering #SQLPerformance

Firebolt

@firebolthq.bsky.social

1 year ago

Distributed query processing in Firebolt YouTube video by Firebolt

Queries slow down at scale—but they don’t have to.

Cole Bowden explains how we optimize query performance for TB-scale workloads using distributed query execution and smart shuffle optimization.

👉 youtu.be/Ue42afyaU_0

#DataEngineering #QueryOptimization #SQLPerformance

Victor on Software

@victoronsoftware.com

1 year ago

3 database gotchas when building apps for scale Database issues that arise when scaling applications

We hit these database issues when scaling applications:
- Excessive database locks
- Read-after-write consistency
- Index limitations
#SQLPerformance #SQLDeveloper #DatabaseScaling #MySQL #DatabaseAdministration
victoronsoftware.com/posts/databa...

DOAG e.V.

@doagev.bsky.social

5 years ago

"Make it Faster: Myths about SQL Performance" – bei der APEX connect 2020 [Online] zeigte @dani_schnider, wie sich Performance-Probleme bereits bei der Entwicklung vermeiden lassen. Zur Aufzeichnung der Session: http://ow.ly/NhwR50BGpwZ #APEXCONN20 #SQLPerformance