article thumbnail

Performance of ULID and UUID in Postgres Database

DZone

These are measurements of search speed by key and data types for the key on the database side. I will use a PostgreSQL database and a demo Java service to compare query speeds. In this article, I want to share my knowledge and opinion about the data types that are often used as an identifier.

Database 286
article thumbnail

Transforming Business Outcomes Through Strategic NoSQL Database Selection

DZone

We often dwell on the technical aspects of database selection, focusing on performance metrics , storage capacity, and querying capabilities. Yet, the impact of choosing the right NoSQL database goes beyond these parameters; it affects your business outcomes.

Database 268
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

API and Database Performance Optimization Strategies

DZone

In today's fast-paced digital landscape, performance optimization plays a pivotal role in ensuring the success of applications that rely on the integration of APIs and databases. Efficient and responsive API and database integration is vital for achieving high-performing applications.

Database 244
article thumbnail

AI-powered infrastructure monitoring for your SAP HANA database (Preview)

Dynatrace

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. However, if you’re an operations engineer who’s been tasked with migrating to HANA from a legacy database system, you’ll need to get up to speed quickly.

article thumbnail

Speeding Up Restores in Percona Backup for MongoDB

Percona

When you do a database restore, you want to have it done as soon as possible. And the database is unusable until the restore is done. Bringing physical backups in Percona Backup for MongoDB (PBM) was a big step toward the restoration speed. Our tests showed physical database restores up to 5x faster than the logical ones.

Speed 78
article thumbnail

Best Practices for Picking PostgreSQL Data Types

DZone

Determining the most appropriate data types to store the information depends on various factors, including the required precision of float-point values, the content of the values (such as text), compressibility, and query speed. Choosing the right data types in PostgreSQL can significantly impact your database's performance and efficiency.

article thumbnail

Keep Your Database Secure With Percona Advisors

Percona

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. For the sake of simplicity and speed, I will use Percona Operator for MySQL (based on Percona Server for MySQL which is in tech preview).

Database 103