Remove 2016 Remove Database Remove Processing Remove Tuning
article thumbnail

Is MongoDB Open Source? Is Planet Earth Flat?

Percona

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. 2016: The company adds service-loaded MongoDB Professional to its mix.

article thumbnail

Reinventing Performance Testing: New Architectures

Alex Podelko

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. I decided to publish a few parts here to see if anything triggers a discussion. It would be published as separate posts: – Introduction (a short teaser).

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

The challenge is on! Community call for creating the fastest number series generator

SQL Performance

I mainly experimented with different table value constructor cardinalities, with serial versus parallel processing, and with row mode versus batch mode processing. You can create supporting tables in the user database if needed. The plan is serial, and all operators in the plan use row mode processing by default.

C++ 114
article thumbnail

The challenge is on! Community call for creating the fastest number series generator

SQL Performance

I mainly experimented with different table value constructor cardinalities, with serial versus parallel processing, and with row mode versus batch mode processing. You can create supporting tables in the user database if needed. The plan is serial, and all operators in the plan use row mode processing by default.

C++ 61
article thumbnail

An Argument for Logical Failover Slots

Percona

Recall that logical replication works by using the PUB/SUB mode, where individual tables are published and are then subscribed by remotely connected databases/tables. The challenge, of course, is reconstituting the logical replication process as quickly as possible, ideally without any data loss. Stay tuned folks; the game is afoot.

Games 91
article thumbnail

Common SQL Server Mishaps

SQL Performance

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49
article thumbnail

5 tips for architecting fast data applications

O'Reilly Software

We live in the era of the connected experience, where our daily interactions with the world can be digitized, collected, processed, and analyzed to generate valuable insights. Accumulating all this data to process overnight is not an option anymore. Do we need to process each record individually? Process tolerance.