DZone

JANUARY 10, 2025

SQL Server is a powerful relational database management system (RDBMS), but as datasets grow in size and complexity, optimizing their performance becomes critical. Leveraging AI can revolutionize query optimization and predictive maintenance, ensuring the database remains efficient, secure, and responsive.

Servers 278

Servers Performance Database Efficiency 278

DZone

OCTOBER 21, 2024

In this blog, I'll describe a couple of new performance features that you'll find in Postgres 17 as well as another important logical replication feature that I didn't cover in my earlier blog of this series. After a successful 3rd beta in August 2024, the PostgreSQL development group released the GA version on September 26th.

Performance 281

Performance Open Source Google Database 281

DZone

JUNE 2, 2025

PostgreSQL 17 introduces several performance improvements and features that make it a powerhouse for Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) workloads. This blog will explore advanced performance tuning techniques for PostgreSQL 17 and highlight key improvements compared to versions 15 and 16.

Tuning 147

Tuning Performance Open Source Analytics 147

DZone

FEBRUARY 5, 2025

It's to overcome this challenge that front-end performance has become the norm or optimization among developers. It entails optimizing relative to the performance standards of the user interface elements of a site. End customers experience delays when visiting slow-loading sites, higher bounce rates, and lost business prospects.

Performance 165

Performance Website Efficiency Processing 165

DZone

MAY 12, 2025

Various sophisticated attacks, such as supply chain breaches, ransomware, phishing via malicious email campaigns, and vulnerabilities in cloud and Internet of Things (IOT) environments, need advanced, performance-sensitive solutions that can detect in real time and also respond to and mitigate these attacks.

Artificial Intelligence 222

Artificial Intelligence IoT Performance Internet 222

DZone

MARCH 6, 2025

As organizations scale their data operations in the cloud, optimizing Snowflake performance on AWS becomes crucial for maintaining efficiency and controlling costs. This comprehensive guide explores advanced techniques and best practices for maximizing Snowflake performance, backed by practical examples and implementation strategies.

AWS 165

AWS Performance Best Practices Architecture 165

Scalegrid

MAY 22, 2025

Database performance issues, such as slow queries and high CPU usage, can severely impact your applications. Implementing appropriate indexes is a critical strategy for optimizing database performance, as it helps identify frequently used columns in search conditions and enhances query efficiency.

Database 130

Database Performance Hardware Traffic 130

DZone

FEBRUARY 4, 2025

Understanding Teradata Data Distribution and Performance Optimization Teradata performance optimization and database tuning are crucial for modern enterprise data warehouses.

Performance 173

Performance Tuning Analytics Strategy 173

DZone

FEBRUARY 5, 2025

After optimizing containerized applications processing petabytes of data in fintech environments, I've learned that Docker performance isn't just about speed it's about reliability, resource efficiency, and cost optimization. Let's dive into strategies that actually work in production.

Strategy 147

Strategy FinTech Performance Speed 147

DZone

MAY 21, 2025

In one of the previous articles on identifying issues in your project, Creating a Web Project: Key Steps to Identify Issues, we discussed how to analyze application performance and how collecting metrics can assist in this task. However, identifying a problem is only the first step; action must be taken to resolve it.

Cache 147

Cache Performance Metrics 147

DZone

MARCH 4, 2025

Ive been in that exact spot debugging performance issues at 2 AM, fueled by coffee and frustration. You build a sleek React app, only to watch it slow to a crawl as it grows. Buttons lag, pages take forever to load, and users start bouncing. Sound familiar?

Performance 147

Performance Strategy Testing 147

DZone

NOVEMBER 4, 2024

This article explores the intricacies of vector search using Elasticsearch , focusing on effective techniques and best practices to optimize performance. As data engineers, we are tasked with implementing these sophisticated solutions, ensuring organizations can derive actionable insights from vast datasets.

Retail 130

Retail Performance Best Practices Tuning 130

Percona

JANUARY 6, 2025

At Percona, we’ve always prioritized performance, and recent trends in MySQL’s development have been a point of concern for us. In particular, the performance deterioration in the MySQL 8.4.x y versions caught our attention, as highlighted in Marco Tusas insightful blog post, Sakila, Where Are You Going?

Performance 142

Performance Development Benchmarking 142

Dynatrace

FEBRUARY 4, 2025

To gather more details about the overall end-to-end transaction and its performance, we can copy the trace ID and navigate to the Distributed Tracing app, search for the trace using the ID, and explore the end-to-end trace. The post Debug complex performance issues in production with ease appeared first on Dynatrace news.

Performance 146

Performance Code Processing Availability 146

DZone

MAY 23, 2025

My extensive experience building complex software systems has shown that performance optimization is often the deciding factor between operational success and failure, especially in large-scale environments managing millions of interconnected components.

Software Performance 130

Software Performance Systems Software Software 130

DZone

MAY 15, 2025

Performance isn't optional, but it's critical for user trust and business success. As a fintech API and cloud optimization expert, I constantly face the challenge of balancing quick development with high performance. Starting from payments to trading to real-time customer experiences, the API takes care of everything.

FinTech 147

FinTech Code Performance Cloud 147

DZone

MARCH 24, 2025

As a CTO, my role extends beyond overseeing technical solutions I work closely with engineering teams to ensure performance testing strategies align with business goals. One of the recurring challenges Ive observed is how sanity testing, despite being a simple step, often determines the success or failure of performance testing efforts.

Engineering 130

Engineering Testing Performance Performance Testing 130

DZone

APRIL 8, 2025

The right policy can significantly reduce mean response time without needing faster machines, effectively improving performance for free. Scheduling is crucial in computer system design. uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions waiting for locks.

Performance 147

Performance Metrics Design Systems 147

DZone

MAY 2, 2025

Information technology continues to transform at an accelerated pace because modern businesses seek faster, high-performance applications. JavaScript-based development solutions from the past tend to fall behind when performing complex computations, which produce performance issues along with ineffective execution.

Performance 130

Performance Speed Technology Technology 130

DZone

MAY 20, 2025

However, cluster sizing is one crucial factor in determining the performance and cost efficiency of your Kubernetes deployment. Kubernetes has become the de facto solution for container orchestration when deploying applications in the cloud. It enables developers to scale applications easily and provides reliable management.

Efficiency 130

Efficiency Cloud Performance Development 130

Dynatrace

APRIL 10, 2025

To maintain system health and resolve issues quickly, teams must have reliable monitoring and performance insights across both Linux and Windows nodes within a single Kubernetes cluster. With Dynatrace, you can trace requests and monitor application performance end-to-end, no matter what OS the workloads run on.

Performance 146

Performance Java Operating System Infrastructure 146

DZone

JANUARY 13, 2025

As an example, for a trading application, it is of paramount importance to show changing stock prices for several stocks in a single instance with high performance and accuracy. Therefore, performance in the web application becomes a "must have" and not just a "nice to have." is tailormade for such scenarios.

Performance 130

Performance Mobile Servers Development 130

DZone

JANUARY 22, 2025

Sluggish build times and bloated node_modules folders are issues that many developers encounter but often overlook. Why does this happen? The answer lies in the intricate web of npm dependencies. With every npm install, your project inherits not only the packages you need but also their dependencies, leading to exponential growth in your codebase.

Performance 147

Performance Efficiency Development 147

DZone

JUNE 3, 2025

Performance optimization has become paramount in cloud data warehousing for organisations that need to make decisions based on fast, accurate insights. As cloud-native data platforms become the norm for modern businesses, performance bottlenecks that can slow data processing and query execution times present new challenges.

AWS 113

AWS Cloud Performance Scalability 113

DZone

JUNE 5, 2025

Optimizing a Snowflake data warehouse (DWH) is crucial for ensuring high performance, cost-efficiency, and long-term effectiveness in data processing and analytics.

Efficiency 100

Efficiency Scalability Performance Speed 100

DZone

AUGUST 21, 2024

Having worked with over 50 Snowflake customers across Europe and the Middle East, I've analyzed hundreds of Query Profiles and identified many issues including issues around performance and cost. In this article, I'll explain:

Performance 279

Performance 279

DZone

FEBRUARY 27, 2025

Given that data warehouses handle large volumes of data, performance optimization is a key challenge for architects and DBAs. SQL Server Integration Services (SSIS) is an ETL tool widely used for developing and managing enterprise data warehouses.

Performance 130

Performance Servers Processing Development 130

DZone

SEPTEMBER 23, 2024

Traditional blocking architectures often struggle to keep up performance, especially under high load. With the rise of microservices architecture , there has been a rapid acceleration in the modernization of legacy platforms, leveraging cloud infrastructure to deliver highly scalable, low-latency, and more responsive services.

Performance 287

Performance Latency Architecture Programming 287

DZone

OCTOBER 22, 2024

The PHP opcode generated by the PHP engine is strongly influenced by the way you write your code, not only in terms of the number of statements to accomplish a task. Clearly, it matters a lot, and I think it’s obvious to you.

Code 162

Code Performance Engineering 162

DZone

OCTOBER 8, 2024

Nowadays, many performance testers with many years of experience in IT have a lot of confusion and are still confused about the technologies they worked with and were used in their projects for years. and must have extensive experience in specialized skills. and must have extensive experience in specialized skills.

Engineering 277

Engineering Blockchain Healthcare IoT 277

Dynatrace

OCTOBER 4, 2024

BlackDuck performs a security and vulnerability check, returning a scan result. Fine-tune: Perform data normalization by creating an OpenPipeline configuration that extracts properties according to the SDLC specification. Build : GitHub builds the code changes and creates a deployable image. Test : Playwright executes end-to-end tests.

Software 278

Software Software Development Performance 278

DZone

JUNE 4, 2025

Optimizing SQL queries is essential for ensuring efficient database performance, especially as data volumes continue to grow. Today, the exponential growth of information necessitates efficient SQL query performance. Slow queries can lead to sluggish applications and a poor user experience.

Performance 100

Performance Best Practices Strategy Efficiency 100

DZone

OCTOBER 29, 2024

How do we use the.NET code properties and settings to improve API performance ? Possible Case Where You Could Have Started Facing the Performance Issue This issue could have started when you upgraded your API to.NET Core 3.0

Performance 130

Performance Code 130

DZone

MAY 23, 2025

Rust, WebAssembly, and Edge Computing might sound like buzzwords, but they actually solve real problems around speed and scalability. Read more about them here.

Performance 130

Performance Scalability Speed 130

DZone

MAY 14, 2025

To develop a high-performance mobile application, you need functional code and a responsive, intuitive user experience. As a mobile developer who has spent years working with Android, Ive learned that performance optimization is both art and science.

Mobile 130

Mobile Development Performance Latency 130

DZone

JUNE 6, 2025

PostgreSQL employs sophisticated techniques for data storage and indexing to ensure efficient data management and fast query performance. This guide explores PostgreSQL's mechanisms, showcases practical examples, and includes simulated performance metrics to illustrate the impact of indexing.

Storage 100

Storage Performance Metrics Efficiency 100

Dynatrace

OCTOBER 3, 2024

Dynatrace OTel Collector Understand your applications with ease Due to a lack of contextual insights and actionable intelligence, application teams often find themselves overwhelmed by data, unable to quickly identify the root causes of performance issues.

Performance 290

Performance Architecture Innovation Latency 290